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

99 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
lubber10421462(None) 
blubber10399291blubber
clubber13319591clubber
dubber113814551dubber
flubber14287711flubber
libber104414011libber
lobber104016601lobber
lubbers113913721lubbers
lumber103817771lumber
rubber104715791rubber
slubber113010761slubber
tubber104313201tubber
bibber94613572bibber
blabber10418922blabber
blubbed11338392blubbed
blubbers11408142blubbers
blubbery14294782blubbery
bobber95016742bobber
bubbler103611782bubbler
clabber134210112clabber
clobber13378162clobber
clubbed14307452clubbed
clubbers14378582clubbers
clubbier1434832clubbier
clumber134011442clumber
cobber124116842cobber
cuber95222532cu_ber
cumber124016702cumber
curber104517052curber
dabber114816962dabber
dibber114614712dibber
dobber114015422dobber
drubber12357862drubber
dubbed124113212dubbed
dubbers124011822dubbers
dumber114414172dumber
fabber134814112fabber
fibber134811932fibber
flubbed15306632flubbed
flubbers15346892flubbers
fubbed144711242fubbed
gabber114916602gabber
gibber114112862gibber
glibber1235162glibber
grubber12417912grubber
hobber134114632hobber
jabber173713642jabber
jibber174111242jibber
jobber173813352jobber
lamber104418492lamber
libbers113812832libbers
liber74723622l_iber
limber104316792limber
lobbed113114612lobbed
lobbers113713942lobbers
lobbyer1433912lobbyer
lubberly1543662lubberly
lube64731562lu_be_
lubed85319892lu_bed
lubes74727992lu_bes
luger65322082lu_ger
lugger83916552lugger
luller63415482luller
lumbar103610592lumbar
lumbers113815912lumbers
lumper103816652lumper
lunger75720422lunger
lunier64617602lunier
lunker104718342lunker
lurer54625312lu_rer
lurker103613292lurker
lusher93818762lusher
luster64023672luster
mobber123613462mobber
nabber104913542nabber
nubbier11308132nubbier
number103913222number
plumber13339982plumber
ribber103515492ribber
robber103916532robber
rubbed114515082rubbed
rubbers113913192rubbers
rubbery14337592rubbery
rubier84814742rubier
slabber113311392slabber
slobber11388902slobber
slubbed12339282slubbed
slubbers12349942slubbers
slumber113811002slumber
snubber11277732snubber
sobber104016592sobber
subbed114116672subbed
suber74924502su_ber
tubbed114712222tubbed
tubbers113411252tubbers
tubbier11237742tubbier
tuber75420682tu_ber
umber94617592_umber
yabber136111832yabber

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 Filter178691825510.373479064.3
2DLD Change Limit82551992.62631436.0
3Display Results99990.0303300.0
 (SQL Overall)178691993.02958993.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.