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 “limberer” with Change Limit: [1] [2] [3]

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

134 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
limberer1218705(None) 
limbered13158121limbered
lumberer12177581lumberer
clamberer15185272clamberer
cumberer14266992cumberer
libeler9219002li_beler
limber104316792limb__er
limberest1345512limberest
limberly1544462limberly
limbers113614742limber_s
limbier11349112limb_ier
lingerer9118302lingerer
litterer82810172litterer
lumbered13188232lumbered
lumberers13196012lumberers
numberer12186312numberer
simperer1237172simperer
slumberer13194802slumberer
timbered13137382timbered
ambeer104511603_ambe_er
bickerer16106773bickerer
bitterer10309773bitterer
blubberer12173453blubberer
cambered15129003cambered
cipherer1545573cipherer
clambered16146133clambered
clamberers16174113clamberers
climber13449133climb__er
climbers14318413climber_s
cumbered15157963cumbered
cumberers15176003cumberers
dimeter10411893dim_eter
ditherer12187763ditherer
fibered1337643fi_bered
filterer11258143filterer
fingerer12127223fingerer
gibbered1444303gibbered
glimmered1543103glimmered
hammerer15278143hammerer
hamperer15379093hamperer
hinderer1238273hinderer
imbiber1333593_imbiber
imbower14235663_imbower
impeder12438533_impeder
impurer1136483_impurer
jabberer1944023jabberer
kipperer16294723kipperer
labeler92310183l_abeler
laborer9249503l_aborer
lamber104418493lamb__er
lambers113817113lamber_s
lambert113617113lamber_t
lamberts12348793lamberts
lambier113611643lamb_ier
latherer111310443latherer
letterer8259223letterer
libber104414013li_b_ber
libbers113812833libber_s
libeled10249413li_beled
libelee92510983li_belee
libelers10238623li_belers
libeller10297433li_beller
liber74723623li_b__er
liberal9310193li_beral
libers84721443li_ber_s
liberty1237163li_berty
lieder74912323li__eder
liefer9529573li__efer
liever94611863li__ever
limbate1139213limbate_
limbeck1744173limbe_ck
limbecks1843353limbecks
limbed114513183limb__ed
limbering1488793limbering
limberness1443273limberness
limbuses1234903limbuses
limier83518723lim__ier
limiter92710853lim_iter
limmer104314793lim__mer
limmers113413083limmer_s
limner84112873lim__ner
limners93311563limner_s
limper104117853lim__per
limpers113815223limper_s
limpsier1234433limpsier
linebred1144963linebred
lingered10129643lingered
lingerers10126923lingerers
lippered13287953lippered
listener8158313listener
littered92511383littered
litterers9228193litterers
livener10278943li_vener
livered113111633li_vered
loiterer837083loiterer
lumber103817773lumb__er
lumberly1544683lumberly
lumbermen1543163lumbermen
lumbers113815913lumber_s
membered1535903membered
merer75126233__m_erer
miterer92511333mi_terer
nimbler11358063nimb_ler
numbered13147143numbered
numberers13165153numberers
pamperer14228333pamperer
pilferer1344923pilferer
silverer11216733silverer
simmered1336863simmered
simpered1338253simpered
simperers1335933simperers
sincerer1037203sincerer
sliverer11237633sli_verer
slobberer13153443slobberer
slumbered14215593slumbered
slumberers14203683slumberers
soberer93110353_soberer
tamperer12248893tamperer
temperer12227723temperer
timber104012683timb__er
timbermen1543503timbermen
timbers113111853timber_s
timbery14256893timber_y
timbre10328633timb_re_
timbrel11306563timb_rel
timbres11249353timb_res
tinkerer1286803tinkerer
titterer8268523titterer
umbered121510113_umbered
unlimbered1542743unlimbered
whimperer19123723whimperer
winterer112110443winterer
witherer14187953witherer
yammerer15225483yammerer

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621347.12620511.1
3Display Results1341340.0602233.3
 (SQL Overall)1786911347.60923484.2
 
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.