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

133 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
limbs9611894(None) 
climbs12498721climbs
lambs95921411lambs
libs66732761li_bs
limas75627631limas
limb85429381limb_
limba95414981limba
limbas105313201limbas
limbi96513811limbi
limbo95614811limbo
limbos104712141limbos
limbus105710381limbus
limby125714071limby
limes75636501limes
limns75718391limns
limos75320811limos
limps95522671limps
aims67738182aim_s
bibbs84911582bibbs
bibs84830992bi_bs
bimas95521742bimas
bimbo114811872bimbo
bimbos124610522bimbos
blimps12588152blimps
bombs115818822bombs
chimbs153910302chimbs
climb115413592climb_
climes104720002climes
combs116122962combs
dibs76233682di_bs
dimes85833042dimes
dims75435022dim_s
dumbs105915752dumbs
fibs96329502fi_bs
gambs105721122gambs
gibs75529272gi_bs
gimps105915202gimps
glimes94717522glimes
glims87417672glim_s
hims95230972him_s
iambs95815062iambs
imps86221122_imps
jambs166014622jambs
jibbs16609742jibbs
jibs136724082ji_bs
labs67145122l_abs
lamas75532792lamas
lamb86832142lamb_
lamby125114842lamby
lames75445542lames
lamps95624832lamps
lams66552262lam_s
liars54723162liars
lib57750272li_b_
licks115325392licks
lidos65219882lidos
lids56336462li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
lilos55821872lilos
lilts55822802lilts
lima65734132lim_a
liman75921602liman
limans84816302limans
limbed114513182limbed
limber104316792limber
limbers113614742limbers
limbic12528742limbic
lime66244932lim_e
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limit73126342limit
limits82514142limits
limn66527692lim_n
limo65529732lim_o
limp88432492lim_p
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
limy95727712lim_y
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lips67141442li_ps
liras56021982liras
lis37162272li__s
lisps76913912lisps
lists56628692lists
litas54923772litas
litmus836322litmus
lits46252492li_ts
lives86133192lives
lobs66441082l_obs
lumas75622912lumas
lumps95624982lumps
lums65734242lum_s
mibs85330482mi_bs
mimes95732022mimes
nibs65028312ni_bs
nimbi94910312nimbi
nimbus10377282nimbus
nims66226882nim_s
numbs94913092numbs
pimas94725102pimas
pimps114616982pimps
plumbs12459332plumbs
ribs65833022ri_bs
rimes75634542rimes
rims65936302rim_s
sibbs96211902sibbs
sibs65933542si_bs
simas75727552simas
simps94719762simps
sims65737172sim_s
slimes84722042slimes
slims75423652slim_s
times75630822times
tombs97818732tombs
vims95423312vim_s
wimps125213802wimps
wombs125813342wombs

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.300595636.7
2DLD Change Limit538001331.71631352.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911332.06286659.1
 
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.