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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
lumbers11381591(None) 
clumbers143910411clumbers
cumbers134515411cumbers
lambers113817111lambers
limbers113614741limbers
lubbers113913721lubbers
lumbars11289761lumbars
lumber103817771lumber_
lumpers113514481lumpers
numbers113711241numbers
plumbers14418511plumbers
slumbers123110271slumbers
umbers104215211_umbers
ambers104519582_ambers
blubbers11408142blubbers
bombers134512592bombers
bumblers143710732bumblers
bummers133712442bummers
bumpers133912052bumpers
cambers134017442cambers
clambers144211292clambers
climbers14318412climbers
clubbers14378582clubbers
clumber134011442clumber_
combers134516622combers
crumbers14338242crumbers
cubers105318352cu_bers
cumber124016702cumber_
cummers133713482cummers
curbers115514382curbers
dubbers124011822dubbers
dumber114414172dumber_
dumpers123412662dumpers
embers104116182_embers
flubbers15346892flubbers
fumblers15318712fumblers
fumers113613382fum_ers
gummers123712202gummers
humblers15379802humblers
hummers143813062hummers
humpers142713522humpers
jumblers19358322jumblers
jumpers18399842jumpers
lamber104418492lamber_
lambert113617112lambert
lamberts12348792lamberts
lampers113817332lampers
libbers113812832libbers
libers84721442l_ibers
limber104316792limber_
limmers113413082limmers
limners93311562limners
limpers113815222limpers
lobbers113713942lobbers
lubber104214622lubber_
lubes74727992lu_be_s
lugers74617022lu_gers
luggers93713482luggers
lullers73213352lullers
lumbar103610592lumbar_
lumbered13188232lumbered
lumberer12177582lumberer
lumberers13196012lumberers
lumberly1544682lumberly
lumens85013972lum_ens
lumpens11298262lumpens
lumper103816652lumper_
lungers83817092lungers
lunkers113414602lunkers
lurers64217492lu_rers
lurkers113910082lurkers
lusters73921442lusters
members13258602members
mumblers14328762mumblers
mummers103712842mummers
mumpers133311372mumpers
number103913222number_
ombers104214402_ombers
plumber13339982plumber_
plumbery17315532plumbery
plumpers14357292plumpers
pumpers133113672pumpers
rubbers113913192rubbers
rumblers123610742rumblers
rummers113513652rummers
slubbers12349942slubbers
slumber113811002slumber_
slumbery15296042slumbery
slummers12358932slummers
subers85722642su_bers
summers113616502summers
timbers113111852timbers
tubbers113411252tubbers
tubers85017032tu_bers
tumblers123110622tumblers
umbels104510592_umbels
umber94617592_umber_

Search took 4 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 Filter1786911076710.1261418182.5
2DLD Change Limit107671973.48330913.3
3Display Results97970.0303233.3
 (SQL Overall)178691973.63949104.4
 
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.