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

168 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
limns7571839(None) 
liens56525501liens
limans84816301limans
limas75627631limas
limbs96118941limbs
limens84618031limens
limes75636501limes
limn66527691limn_
limos75320811limos
limps95522671limps
linns56123331linns
lins47059051li_ns
lions55923211lions
aims67738182aim_s
ains46158882ai_ns
airns55521032airns
aliens65619212aliens
aligns75312952aligns
amins75534322amins
bimas95521742bimas
bins66548252bi_ns
blimps12588152blimps
cions75222852cions
climbs12498722climbs
climes104720002climes
damns84916922damns
dimes85833042dimes
dims75435022dim_s
dins56652042di_ns
fins75849092fi_ns
firns86018542firns
gimps105915202gimps
gins55543952gi_ns
girns64516802girns
glimes94717522glimes
glims87417672glim_s
hims95230972him_s
hins76447992hi_ns
hymns1337522hymns
imps86221122_imps
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
jinns126013842jinns
jins115635012ji_ns
kilns95112982kilns
kins85747912ki_ns
kirns95315452kirns
lamas75532792lamas
lambs95921412lambs
lames75445542lames
lamps95624832lamps
lams66552262lam_s
lawns85215422lawns
leans55536252leans
lemans85316392lemans
lemons84415052lemons
lens46146492l_ens
liana53915892liana
lianas63713382lianas
liane54720662liane
lianes63819322lianes
liang64914412liang
liangs74410592liangs
liars54723162liars
libs66732762li_bs
licks115325392licks
lidos65219882lidos
lids56336462li_ds
lien45339802lien_
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
ligans76817732ligans
likens105613702likens
likes96231902likes
lilos55821872lilos
lilts55822802lilts
lima65734132lim_a
liman75921602liman
limb85429382lim_b
limba95414982limba
limbas105313202limbas
limbi96513812limbi
limbo95614812limbo
limbos104712142limbos
limbus105710382limbus
limby125714072limby
lime66244932lim_e
limed85426802limed
limen75426032limen
limey104721042limey
limeys11429272limeys
limina83514502limina
liming94021242liming
limit73126342limit
limits82514142limits
limned94811472limned
limner84112872limner
limners93311562limners
limnic10418842limnic
limo65529732lim_o
limp88432492lim_p
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
limy95727712lim_y
lin37967372li_n_
line46965572li_ne
linens64818392linens
lines57054572lines
ling57447962li_ng
lings67135772lings
linins65922142linins
link86943442li_nk
links96430192links
linn46034592li_nn
lino46343372li_no
linos55631502linos
lint416266232li_nt
lints57137192lints
liny78141322li_ny
lion46334442lion_
lipins85016882lipins
lips67141442li_ps
liras56021982liras
lis37162272li__s
lisps76913912lisps
lists56628692lists
litas54923772litas
litmus836322litmus
lits46252492li_ts
livens94314892livens
lives86133192lives
loans56026462loans
loins56728422loins
loons55731722loons
lumas75622912lumas
lumens85013972lumens
lumps95624982lumps
lums65734242lum_s
miens76118302miens
mimes95732022mimes
nims66226882nim_s
pians75126962pians
pimas94725102pimas
pimps114616982pimps
pins65558452pi_ns
pions75826392pions
pirns76020092pirns
rimes75634542rimes
rims65936302rim_s
rins46153192ri_ns
signs65516322signs
simas75727552simas
simps94719762simps
sims65737172sim_s
sins46755272si_ns
slimes84722042slimes
slims75423652slim_s
times75630822times
tins45251302ti_ns
vims95423312vim_s
wimps125213802wimps
wins75949172wi_ns
yins75335122yi_ns
zins135735002zi_ns

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.390458182.1
2DLD Change Limit538001681.54634799.5
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.98290156.9
 
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.