Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “mines” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

471 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mines7565195(None) 
amines84727981amines
bines76946791bines
cines75239681cines
dines66449151dines
fines86644261fines
imines84918341imines
kines95039131kines
lines57054571lines
manes76648951manes
miens76118301miens
mikes115129891mikes
miles74645071miles
mimes95732021mimes
minas75434111minas
minces104420801minces
minds85427121minds
mine67256151mine_
mined85333351mined
miner76933541miner
miners84126631miners
minis75432981minis
minkes124618781minkes
minks115829271minks
mints76834041mints
minus75223931minus
minxes154612981minxes
mires75640881mires
mises74740561mises
mites75141801mites
mixes147224401mixes
nines55937341nines
pines76048861pines
sines55954821sines
tines54848421tines
vines85137641vines
wines85546861wines
zines145232651zines
acnes75922622acnes
aides65336602aides
ains46158882ain_s
alines65735222alines
amices105018012amices
amides95722662amides
amies76837682ami_es
amine75835372amine_
amins75534312amin_s
ammines11312672ammines
anes45255932_anes
azines155517072azines
banes74945582banes
benes75536232benes
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
binds86627472binds
bine66650852bine_
biner75930692biner
biners85023632biners
binges93923122binges
bins66548242bin_s
bints76130182bints
bises75435622bises
bites75641172bites
bizes165923662bizes
bones76446532bones
brines85028852brines
canes75350372canes
chines115029172chines
cine66242942cine_
cires74932912cires
cites74435582cites
clines84926042clines
cones76457422cones
denes65639722denes
dices86434242dices
dienes75719902dienes
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dine55555332dine_
dined76431992dined
diner65632902diner
diners75525952diners
dinges83825422dinges
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
dites66339152dites
dives95832402dives
domines102918972domines
dunes65332172dunes
dwines105013102dwines
dynes95917582dynes
ermines9416662ermines
ernes55224812ernes
esnes54817362esnes
exines135715802exines
famines123216262famines
fanes84639892fanes
fices106031162fices
fifes114822392fifes
files85441272files
finds95424822finds
fine75147952fine_
fined94930502fined
finer85431562finer
finest94321732finest
finis86824252finis
finks125424222finks
finos86226942finos
fins75849092fin_s
fires85740752fires
fives116027362fives
fixes154723592fixes
gamines103618462gamines
genes65133092genes
gibes84422522gibes
gies55641422gi_es
ginks104319562ginks
gins55543952gin_s
gites65630182gites
gives95324872gives
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hinds96721472hinds
hinges105121022hinges
hins76447992hin_s
hints87330622hints
hires86134342hires
hives116925512hives
homines123518632homines
hones88144492hones
ices66129642_ices
ides57734232_ides
imides94515332imides
imine75821042imine_
inks86926502_inks
inns46920932_inns
ins35945602_in_s
ires45639282_ires
janes124928122janes
jibes145520322jibes
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
jinxes20428232jinxes
jives154820812jives
jones125028182jones
kanes95529372kanes
kibes115521112kibes
kikes85122552kikes
kinas95626912kinas
kinds106221812kinds
kine85643422kine_
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kites95432542kites
koines10415732koines
lanes54946792lanes
lenes54738522lenes
lianes63819322lianes
liens56525502liens
lies46454192li_es
likes96231902likes
limes75636502limes
line46965572line_
lined64934642lined
linen55728722linen
linens64818392linens
liner55938912liner
liners65428842liners
liney87029622liney
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
lives86133192lives
lunes55337772lunes
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
mailes84329112mailes
mains75635092main_s
maizes175115732maizes
makes115336852makes
males75049792males
malines93625602malines
manas76240422manas
mane65052012mane_
maned86634092maned
manges94628942manges
manos74933612manos
mans66354532man_s
manse75528222manse
manses84225512manses
mantes84430782mantes
manus75924922manus
mares76457632mares
marines93928012marines
mates75251362mates
maxes145629532maxes
mazes165632172mazes
meinies92516072meinies
memes94927702memes
mends84927692mends
mense75025632mense
menses84222452menses
menus75822842menus
meres75143572meres
mesnes85216212mesnes
metes74736212metes
mezes167719262mezes
mibs85330462mi_bs
micas96823052micas
mice87442222mice_
miches134320732miches
micks135525372micks
mics87435142mi_cs
midges103516472midges
midis85923402midis
mids76541772mi_ds
mien65028352mi_en
miffs134512872miffs
miggs96311372miggs
migs76935312mi_gs
mike105535282mike_
miked125020452miked
milds86422052milds
mile66352562mile_
miler75733062miler
milers84625162milers
milks115020582milks
milles84526562milles
mills75435052mills
milneb1095952milneb
milnebs11113792milnebs
milos75428012milos
mils66045322mi_ls
milts75430712milts
mime85736392mime_
mimed105622732mimed
mimeo96018682mimeo
mimeos104511542mimeos
mimer94825762mimer
mimers105520182mimers
mina65136902min_a
minae75627722minae
mince95325232mince
minced114114902minced
mincer104017362mincer
mincers113714842mincers
mincy125817412mincy
mind75434362min_d
minded103817832minded
minder94822502minder
minders103720112minders
mingles103719002mingles
mingy115520182mingy
mini65634542min_i
minim97321592minim
minims104514802minims
minish115216292minish
mink106636512min_k
minke115421762minke
minnies93617362minnies
minny104518662minny
minor74920062minor
minors85117092minors
mint66758042min_t
minted94220582minted
minter84425102minter
minters93822462minters
minty106323902minty
minuet82621032minuet
minuets9259852minuets
minuses93512702minuses
minutes93513432minutes
minx137723332min_x
mioses84318852mioses
mips85534072mi_ps
mire66748222mire_
mired85729222mired
mirex146816622mirex
mirks115122142mirks
mirs66940562mi_rs
mis58162612mi__s
mise66043572mise_
miser75430402miser
misers85025702misers
misos76523292misos
miss65339412mi_ss
misses85130872misses
mists76633902mists
mite66249402mite_
miter75734792miter
miters84328772miters
mitis75425982mitis
mitres83922072mitres
mitts75523752mitts
mixed155717252mixed
mixer145017642mixer
mixers154513562mixers
mizen164815272mizen
mizens174610252mizens
modes85537412modes
moires8915632moires
mokes114631032mokes
moles74747922moles
momes95134472momes
monas74732152monas
mondes94322352mondes
money104826842money
moneys115513622moneys
monies83233162monies
monks116123392monks
monos75930862monos
mons68152252mon_s
montes84226932montes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
mules75034292mules
munis75022002munis
muns65535912mun_s
mures75937212mures
murines93718222murines
muses75134302muses
mutes75033782mutes
mutines93117822mutines
mynas105815232mynas
nenes55329672nenes
nides65229132nides
nine45842172nine_
nites55736342nites
nixes124519622nixes
nones55639132nones
oinks94819912oinks
ones46146532_ones
opines84820702opines
ovines94614342ovines
panes76148692panes
penes75839222penes
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pinas75434452pinas
pine67755712pine_
pined85935322pined
piney105727502piney
pings85830882pings
pinks115729382pinks
pins65558452pin_s
pints75936222pints
pipes96030142pipes
pixes144323172pixes
pones74547042pones
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
rinse54820972rinse
rinses64720382rinses
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
runes55530222runes
sanes55649072sanes
seines65029902seines
shines95028912shines
sices75637272sices
sides65838362sides
sikes96236082sikes
sine46560622sine_
sinew84718922sinew
sinews94210622sinews
singes74326852singes
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
smiles84522292smiles
smites83921922smites
sones55444142sones
spines85132032spines
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tine45855132tine_
tinea54923152tinea
tineas64616472tineas
tined65434532tined
tinges74722322tinges
tings65329192tings
tins45251302tin_s
tints56030922tints
tires55437492tires
tones56048662tones
trines64132562trines
tunes55332192tunes
twines94717272twines
tynes85920302tynes
urines64724122urines
vanes85130972vanes
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vinas85126342vinas
vine75643682vine_
vined95626152vined
vinos84723072vinos
vires84529682vires
vises84427772vises
wanes85040882wanes
whines125120102whines
wides94832822wides
wifes114522562wifes
wiles85437872wiles
winces114819112winces
winds95425602winds
wine74953422wine_
wined94434182wined
winey115325432winey
wings95727242wings
winks125325432winks
winoes94317012winoes
winos84625042winos
wins75949172win_s
winzes184313052winzes
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
yikes125117752yikes
yins75335122yin_s
yipes106017842yipes
zincs165312932zincs
zine137036152zine_
zineb165614142zineb
zinebs17606802zinebs
zings154620892zings
zins135735002zin_s
zones145528042zones

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.1101624463.6
2DLD Change Limit538004711.61033416.1
3Display Results4714710.1263738.1
 (SQL Overall)1786914711.84696799.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.