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

152 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
limos7532081(None) 
lidos65219881lidos
lilos55821871lilos
limas75627631limas
limbos104712141limbos
limbs96118941limbs
limes75636501limes
limns75718391limns
limo65529731limo_
limps95522671limps
linos55631501linos
aims67738182aim_s
alamos8415002alamos
aliyos9349532aliyos
ammos94815822ammos
bigos85020012bigos
bimas95521742bimas
bimbos124610522bimbos
bios66335322bi_os
biros75325132biros
blimps12588152blimps
camos95927612camos
climbs12498722climbs
climes104720002climes
demos86022992demos
didos76820812didos
dimes85833042dimes
dims75435022dim_s
dinos65428062dinos
eidos65817752eidos
fidos95819052fidos
filos86125382filos
finos86226952finos
gimps105915202gimps
giros65722652giros
gismos957182gismos
gizmos1844132gizmos
glimes94717522glimes
glims87417672glim_s
hims95230972him_s
homos105921782homos
imps86221122_imps
kilos95021472kilos
kinos96626142kinos
lamas75532792lamas
lambs95921412lambs
lames75445542lames
lamps95624832lamps
lams66552262lam_s
lemon75618182lemon
lemons84415052lemons
lenos56024862lenos
liars54723162liars
libs66732762li_bs
licks115325392licks
lido56028162lido_
lids56336462li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
lilo46731562lilo_
lilts55822802lilts
lima65734132lim_a
liman75921602liman
limans84816302limans
limb85429382lim_b
limba95414982limba
limbas105313202limbas
limbi96513812limbi
limbo95614812limbo
limbus105710382limbus
limby125714072limby
lime66244932lim_e
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limit73126342limit
limits82514142limits
limn66527692lim_n
limp88432492lim_p
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
limy95727712lim_y
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
lino46343372lino_
lins47059052li_ns
lints57137192lints
lion46334442li_on
lions55923212lions
lips67141442li_ps
liras56021982liras
lirot5430032lirot
lis37162272li__s
lisps76913912lisps
lists56628692lists
litas54923772litas
lithos94212552lithos
litmus836322litmus
lits46252492li_ts
lives86133192lives
lobos75921842lobos
locos75822602locos
logos67225332logos
looms75124642looms
loos49051122l_oos
lotos54724632lotos
lumas75622912lumas
lumps95624982lumps
lums65734242lum_s
memos95719112memos
milos75428012milos
mimeos104511542mimeos
mimes95732022mimes
mimosa1036362mimosa
misos76523292misos
mos57067122__mos
nims66226882nim_s
nomos75919742nomos
olios54520852oli_os
pimas94725102pimas
pimps114616982pimps
pisos76021062pisos
pomos95321582pomos
primos104514422primos
rimes75634542rimes
rimose8310592rimose
rimous8311912rimous
rims65936302rim_s
silos56029432silos
simas75727552simas
simps94719762simps
sims65737172sim_s
sixmos1534812sixmos
skimos12548802skimos
slimes84722042slimes
slims75423652slim_s
sumos75720092sumos
times75630822times
tiros54524892tiros
vims95423312vim_s
vinos84723072vinos
wimps125213802wimps
winos84625042winos

Search took 3 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.296603685.8
2DLD Change Limit538001521.73630990.8
3Display Results1521520.0463304.3
 (SQL Overall)1786911522.07885991.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.