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 “milks” 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.

199 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
milks11502058(None) 
bilks115117891bilks
ilks87218571_ilks
micks135525371micks
milds86422051milds
miles74645071miles
milk105028471milk_
milky144014441milky
mills75435051mills
milos75428011milos
mils66045331mil_s
milts75430711milts
minks115829271minks
mirks115122141mirks
silks94620681silks
ails45654712ail_s
balks114926292balks
biles75542142biles
bilk105824422bilk_
bills75632862bills
birks114920302birks
bisks115416802bisks
bulks115920612bulks
calks115421602calks
dicks125824692dicks
dills65530972dills
dinks105927952dinks
dirks105619522dirks
disks105417472disks
elks85820032_elks
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
finks125424222finks
folks126017122folks
gilds75417522gilds
gills64728192gills
gilts64924262gilts
ginks104319562ginks
hicks145322172hicks
hills85431352hills
hilts86924412hilts
hilus84817642hilus
holks124720562holks
hulks125715482hulks
ilk78325302_ilk_
ilka87215152_ilka
ills47030422_ills
inks86926502_inks
irks86220132_irks
jills125122822jills
jilts124717412jilts
jinks165019332jinks
kicks104420082kicks
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kinks84926082kinks
kirks84915262kirks
kliks8398822kliks
licks115325392licks
lilos55821872lilos
lilts55822802lilts
links96430192links
macks135127602macks
mailes84329112mailes
maills84215282maills
mails76037782mail_s
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
marks115933482marks
masks115320532masks
melds84822382melds
mells75031332mells
mels65941532mel_s
melts74930102melts
merks114722402merks
mibs85330482mi_bs
micas96823052micas
mick126333432mick_
mics87435152mi_cs
midis85923412midis
mids76541782mi_ds
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mike105535292mi_ke
mikes115129892mikes
mil55752112mil__
milch124413372milch
mild75330852mil_d
mile66352572mil_e
miler75733062miler
milers84625162milers
milia72719572milia
milked134612572milked
milker124814322milker
milkers134411612milkers
milksop1542832milksop
mill66541482mil_l
mille75029132mille
milles84526562milles
milo65536102mil_o
milpa92111402milpa
milpas101710272milpas
milt65455812mil_t
milty104720072milty
mimes95732022mimes
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
mink106636522mink_
minke115421762minke
minkes124618782minkes
mints76834042mints
minus75223932minus
mips85534082mi_ps
mires75640882mires
mirk106729502mirk_
mirky146315522mirky
mirs66940572mi_rs
mis58162622mi__s
mises74740562mises
misos76523292misos
miss65339422mi_ss
mists76633902mists
mites75141802mites
mitis75425992mitis
mitts75523752mitts
mixes147224402mixes
mocks135023822mocks
moils76125752moil_s
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monks116123392monks
mosks116117002mosks
mucks134622642mucks
mules75034292mules
mulls75124152mulls
murks114821722murks
musks116119642musks
nicks114920492nicks
nills54926672nills
nils46132452nil_s
oils46337972oil_s
oinks94819912oinks
picks135226142picks
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pinks115729382pinks
ricks115126132ricks
riles55343642riles
rills55032712rills
rinks94827102rinks
risks94917062risks
sicks115127622sicks
silds65520522silds
silk85529322silk_
silky125315822silky
sills55135982sills
silos56029422silos
silts55330822silts
sinks95529182sinks
smiles84522292smiles
smirks124910122smirks
sulks94818462sulks
talks94322692talks
ticks115823292ticks
tilaks1097352tilaks
tiles55542102tiles
tills54631702tills
tils45739612til_s
tilts55325612tilts
umiaks1244952umiaks
vills86429322vills
walks126218502walks
wicks144619362wicks
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winks125325432winks
yelks126413622yelks
yills83921552yills
yolks125412772yolks
zills144020782zills

Search took 6 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.1701051123.5
2DLD Change Limit538001994.58011746.7
3Display Results1991990.1561275.6
 (SQL Overall)1786911994.90636423.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.