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

121 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
lumberer1217758(None) 
cumberer14266991cumberer
limberer12187051limberer
lumbered13188231lumbered
lumberers13196011lumberers
numberer12186311numberer
slumberer13194801slumberer
blubberer12173452blubberer
clamberer15185272clamberer
cumbered15157962cumbered
cumberers15176002cumberers
limbered13158122limbered
lumber103817772lumb__er
lumberly1544682lumberly
lumbermen1543162lumbermen
lumbers113815912lumber_s
numbered13147142numbered
numberers13165152numberers
slumbered14215592slumbered
slumberers14203682slumberers
umbered121510112_umbered
ambeer104511603_ambe_er
austerer838383austerer
blubbered13164113blubbered
blubberers13162843blubberers
blunderer1244543blunderer
blusterer11176293blusterer
bumbler134013233bumb_ler
bumpered1536003bumpered
cambered15129003cambered
clambered16146133clambered
clamberers16174113clamberers
clumber134011443clumb__er
clumbers143910413clumber_s
cumber124016703cumb__er
cumbers134515413cumber_s
cupbearer1542403cupbearer
dumber114414173dumb__er
flutterer12185263flutterer
fumbler143610813fumb_ler
furbearer1443033furbearer
hammerer15278143hammerer
hamperer15379093hamperer
humbler143411943humb_ler
jabberer1944023jabberer
jumbler183910273jumb_ler
labeler92310183l_abeler
laborer9249503l_aborer
lamber104418493lamb__er
lambers113817113lamber_s
lambert113617113lamber_t
lamberts12348793lamberts
lambier113611643lamb_ier
latherer111310443latherer
launderer1094513launderer
letterer8259223letterer
libeler9219003l_ibeler
limber104316793limb__er
limberest1345513limberest
limberly1544463limberly
limbers113614743limber_s
limbier11349113limb_ier
lingerer9118303lingerer
litterer82810173litterer
loiterer837083loiterer
lubber104214623lu_b_ber
lubberly1543663lubberly
lubbers113913723lubber_s
lumbar103610593lumb__ar
lumbars11289763lumbar_s
lumbering14117933lumbering
lumberman1542783lumberman
lumberyard1851383lumberyard
lumper103816653lum__per
lumpers113514483lumper_s
lumpier113410143lum_pier
lurer54625313lu___rer
lustered92510603lustered
membered1535903membered
merer75126233__m_erer
mumbler133510913mumb_ler
murderer1145263murderer
mutterer10218913mutterer
number103913223numb__er
numbers113711243number_s
pamperer14228333pamperer
plumber13339983plumb__er
plumberies1645123plumberies
plumbers14418513plumber_s
plumbery17315533plumber_y
plunderer1243753plunderer
puckerer1645793puckerer
putterer10209913putterer
quaverer2054583quaverer
queerer16106503qu_eerer
quiverer2044463quiverer
rubbered1335383rubbered
rubberier1344393rubberier
rumbler113514113rumb_ler
simperer1237173simperer
slobberer13153443slobberer
slubbered14175253slubbered
slumber113811003slumb__er
slumbers123110273slumber_s
slumbery15296043slumber_y
soberer93110353_soberer
sufferer1436063sufferer
summered1338143summered
summerier1346423summerier
sunderer9310523sunderer
tamperer12248893tamperer
temperer12227723temperer
timbered13137383timbered
tumbler113412823tumb_ler
tumbrel11406853tumb_rel
umbeled12208193_umbeled
umber94617593_umb__er
umbers104215213_umber_s
upbearer1243583_upbearer
utterer71910463_utterer
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 Limit1461621217.45319611.2
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.92222556.3
 
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.