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

242 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
rubbery1433759(None) 
robbery14348281robbery
rubber104715791rubber_
rubbers113913191rubbers
bibbery13426542bibbery
blubbery14294782blubbery
bobbery13438352bobbery
drubber12357862drubber_
drubbers13386032drubbers
dubber113814552dubber_
dubbers124011822dubbers
grubber12417912grubber_
grubbers13316202grubbers
jobbery21366012jobbery
lubber104214622lubber_
lubberly1543662lubberly
lubbers113913722lubbers
ribber103515492ribber_
ribbers113913182ribbers
robber103916532robber_
robbers112814162robbers
rubbed114515082rubbe_d
rubbered1335382rubbered
rubbly133710612rubb_ly
rubby124413862rubb__y
rubier84814742rubier_
rudery10419032ru_dery
shrubbery1941702shrubbery
tubber104313202tubber_
tubbers113411252tubbers
abbey125714933_abbe_y
ambery133811133_ambery
beery105220123__beery
bibber94613573bibber_
bibbers103911353bibbers
blubber10399293blubber_
blubbers11408143blubbers
bobber95016743bobber_
bobbers103614283bobbers
bribery14426493bribery
bubbler103611783bubbler_
bubblers11448943bubblers
bubbly124110353bubb_ly
bubby115013933bubb__y
buggery14367933buggery
butlery12369423butlery
buttery124311193buttery
clubber13319593clubber_
clubbers14378583clubbers
cobber124116843cobber_
cobbers134114753cobbers
crabber133810733crabber_
crabbers14358753crabbers
cribber13367663cribber_
cribbers14306443cribbers
crumber13339643crumber_
crumbers14338243crumbers
cubby145212123cubb__y
cuber95222533cu_ber_
cubers105318353cu_bers
cumber124016703cumber_
cumbers134515413cumbers
curber104517053curber_
curbers115514383curbers
cutlery12448393cutlery
dabber114816963dabber_
dabbers123813213dabbers
daubery13396213daubery
dibber114614713dibber_
dibbers124013173dibbers
dobber114015423dobber_
dobbers123513253dobbers
drabber12438593drabber_
drubbed13406983drubbe_d
drudgery14273633drudgery
dubbed124113213dubbe_d
dubiety1344593dubiety
dumber114414173dumber_
dupery12378743du_pery
fabber134814113fabber_
fibber134811933fibber_
fibbers144510603fibbers
flubber14287713flubber_
flubbers15346893flubbers
fubbed144711243fubbe_d
fullery13337973fullery
gabber114916603gabber_
gabbers124612833gabbers
gibber114112863gibber_
gibbers124710983gibbers
grabber12389763grabber_
grabbers13337883grabbers
grubbed13406433grubbe_d
grubbier13344753grubbier_
grubbily1642973grubbily
grubby14324503grubb__y
gunnery11376373gunnery
guttery11427763guttery
hobber134114633hobber_
hobbers143512343hobbers
hubbly16478413hubb_ly
hubby155011403hubb__y
jabber173713643jabber_
jabbers183610583jabbers
jibber174111243jibber_
jibbers18449703jibbers
jobber173813353jobber_
jobbers182911133jobbers
libber104414013libber_
libbers113812833libbers
lobber104016603lobber_
lobbers113713943lobbers
lumber103817773lumber_
lumberly1544683lumberly
lumbers113815913lumbers
mobber123613463mobber_
mobbers133610923mobbers
mulberry1542563mulberry
mummery13336663mummery
nabber104913543nabber_
nabbers113710463nabbers
nabobery1542433nabobery
nubbier11308133nubbier_
nubbly13369673nubb_ly
nubby125011033nubb__y
number103913223number_
numbers113711243numbers
nunnery10355303nunnery
nursery10396023nursery
plumbery17315543plumbery
prudery1335253pru_dery
puberty1444783pu_berty
puckery18306263puckery
puffery18235113puffery
quavery22225483quavery
query174212083qu__ery
quivery22265463quivery
rabbet103818653rabbe_t
rabbets11279423rabbets
rabbitry15243383rabbitry
rabbity14266303rabbity
rabbler113514093rabbler_
rabblers123810853rabblers
rebbe9313163rebbe__
rebbes10313533rebbe_s
rebury11349213r_ebury
revery124014213r_every
ribbed114014373ribbe_d
ribbier1137593ribbier_
ribbony1443543ribbony
ribby12419683ribb__y
ribier84414233ribier_
ribiers9319753ribiers
riflery13345803riflery
robbed113415193robbe_d
robotry1244173robotry
rockery16439253rockery
roguery1134893roguery
rookery14398313rookery
ropery114313873r_opery
rosery93813283r_osery
rubberier1344393rubberier
rubbering1435703rubbering
rubberize22133693rubberize
rubbies114114113rubbies
rubbing123412273rubbing
rubbish1436303rubbish
rubbishy1842153rubbishy
rubble104315673rubb_le
rubbled124611623rubbled
rubbles113715113rubbles
rubblier1244913rubblier_
rubboard1343983rubboard
rube65532013ru_be__
rubel75416833ru_be_l
rubels84112993ru_bels
rubes74928413ru_be_s
rubied94312413rubie_d
rubies84420343rubie_s
rubiest92914423rubiest
ruble74521253ruble__
rubles83921703ruble_s
ruby97819943ru_b__y
rudder83812803rudder_
rudders93210653rudders
rudely10389973ru_dely
ruder65320543ru_der_
ruer46127563ru__er_
ruers515019413ru__ers
rugby11448133rugb__y
rugger84414513rugger_
ruggers94612313ruggers
ruiner64013643ruiner_
ruiners74213023ruiners
ruler54923343ru_ler_
rulers64317093ru_lers
rulier65016353rulier_
rumbler113514113rumbler_
rumblers123610743rumblers
rumbly134412163rumb_ly
rummer104715483rummer_
rummers113513653rummers
runner63814463runner_
runners74212453runners
rusher94019653rusher_
rushers103816103rushers
russety1034613russety
scrubber1434123scrubber_
scrubbers1543373scrubbers
slabbery15375773slabbery
slobbery15375663slobbery
slubber113010763slubber_
slubbers12349943slubbers
slumbery15296043slumbery
snobbery15514293snobbery
snubber11277733snubber_
snubbers12326673snubbers
sobber104016593sobber_
sobbers114114263sobbers
subbed114116673subbe_d
suber74924503su_ber_
subers85722643su_bers
subsere9311443subsere
subvert12312893subvert
subzero1835613subzero
summery14329413summery
surgery11319213surgery
timbery14256893timbery
trumpery1533613trumpery
tubbed114712223tubbe_d
tubbier11237743tubbier_
tubby124511403tubb__y
tuber75420683tu_ber_
tubers85017033tu_bers
turbary1236383turbary
turnery10357423turnery
tushery1335633tushery
ubiety1135913_ubiety
umber94617593_umber_
umbers104215213_umbers
yabber136111833yabber_
yabbers14389353yabbers

Search took 9 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272428.18616372.7
3Display Results2422420.0932602.2
 (SQL Overall)1786912428.66920612.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.