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

104 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
rubber10471579(None) 
drubber12357861drubber
dubber113814551dubber
grubber12417911grubber
lubber104214621lubber
ribber103515491ribber
robber103916531robber
rubbed114515081rubbed
rubbers113913191rubbers
rubbery14337591rubbery
rubier84814741rubier
tubber104313201tubber
bibber94613572bibber
blubber10399292blubber
bobber95016742bobber
bubbler103611782bubbler
clubber13319592clubber
cobber124116842cobber
crabber133810732crabber
cribber13367662cribber
crumber13339642crumber
cuber95222532cu_ber
cumber124016702cumber
curber104517052curber
dabber114816962dabber
dibber114614712dibber
dobber114015422dobber
drabber12438592drabber
drubbed13406982drubbed
drubbers13386032drubbers
dubbed124113212dubbed
dubbers124011822dubbers
dumber114414172dumber
fabber134814112fabber
fibber134811932fibber
flubber14287712flubber
fubbed144711242fubbed
gabber114916602gabber
gibber114112862gibber
grabber12389762grabber
grubbed13406432grubbed
grubbers13316202grubbers
grubbier13344752grubbier
hobber134114632hobber
jabber173713642jabber
jibber174111242jibber
jobber173813352jobber
libber104414012libber
lobber104016602lobber
lubbers113913722lubbers
lumber103817772lumber
mobber123613462mobber
nabber104913542nabber
nubbier11308132nubbier
number103913222number
rabbet103818652rabbet
rabbler113514092rabbler
rebbe9313162rebbe_
rebbes10313532rebbes
ribbed114014372ribbed
ribbers113913182ribbers
ribbier1137592ribbier
ribier84414232ribier
robbed113415192robbed
robbers112814162robbers
robbery14348282robbery
rubbered1335382rubbered
rubbies114114112rubbies
rubble104315672rubble
rubbled124611622rubbled
rubbles113715112rubbles
rubblier1244912rubblier
rubbly133710612rubbly
rubby124413862rubb_y
rube65532012ru_be_
rubel75416832ru_bel
rubes74928412ru_bes
rubied94312412rubied
rubies84420342rubies
ruble74521252ruble_
rubles83921702rubles
rudder83812802rudder
ruder65320542ru_der
ruer46127562ru__er
rugger84414512rugger
ruiner64013642ruiner
ruler54923342ru_ler
rulier65016352rulier
rumbler113514112rumbler
rummer104715482rummer
runner63814462runner
rusher94019652rusher
scrubber1434122scrubber
slubber113010762slubber
snubber11277732snubber
sobber104016592sobber
subbed114116672subbed
suber74924502su_ber
tubbed114712222tubbed
tubbers113411252tubbers
tubbier11237742tubbier
tuber75420682tu_ber
umber94617592_umber
yabber136111832yabber

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 Filter178691825510.343520965.0
2DLD Change Limit825511042.39334496.9
3Display Results1041040.0303466.7
 (SQL Overall)1786911042.76664602.7
 
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.