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

355 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
rugbies1033935(None) 
rubbies114114111rubbies
rubies84420341ru_bies
brumbies1436532brumbies
bubbies103913512bubbies
buggies114613812buggies
busbies113011692busbies
cubbies133312882cubbies
druggies11126222druggies
hubbies143211562hubbies
luggies93011212luggies
rabbies113416052rabbies
rabies85226022r_abies
raggies93214732raggies
roughies1298322roughies
rubbles113715112rubbles
rubes74928412ru_b_es
rubied94312412ru_bied
rubier84814742ru_bier
rubiest92914422ru_biest
rubles83921702ru_bles
rumbles114018392rumbles
rummies113212792rummies
uglies7412322_uglies
aggies83515513_aggies
alibies9313323alibies
argufies1243743argufies
augites8312183augites
auguries947933auguries
aunties73920073aunties
babies106123653_babies
baggies113814853baggies
barbies114519593barbies
biggies113813523biggies
bilbies114712343bilbies
bobbies103714563bobbies
bogies94724313bog_ies
boobies113718203boobies
bougies103715183boug_ies
brulyies1343423brulyies
brulzies1933983brulzies
bubbles104315963bubbles
bubblies1166773bubblies
bubkes144612623bu_bkes
buboes104513993bu_boes
buddies113914353buddies
budgies115312513budgies
bugbanes1345153bugbanes
bugeyes1335513bugeyes
buggier113611343buggier
buggiest123410363buggiest
bugles94822443bug_les
bulbils11338333bulbils
bullies94121893bullies
bumbles134016843bumbles
bunnies94415003bunnies
buppies133011063buppies
burbles114916803burbles
burdies104117563burdies
buries84633273bu_ries
burnies94017823burnies
busies85525263bu_sies
butties93217953butties
cabbies133115163cabbies
corbies113520123corbies
crumbier1456363crumbier
crumbiest1536253crumbiest
crumbles14329683crumbles
crummies1437643crummies
cubes95028163cu_b_es
cubics123810163cu_bics
cubits103714033cu_bits
cuddies113313263cuddies
cullies94419963cullies
cumbias13338963cumbias
curies84934023cu_ries
curries93723163curries
cuties84927363cu_ties
cutties93118843cutties
darbies104216983darbies
derbies103016053derbies
dobbies124113063dobbies
dobies94422093_dobies
doggies103613023doggies
dogies85022253dog_ies
doobies103915673doobies
druggie10134073druggie_
druggier11134833druggier
druggiest12134973druggiest
drumbles13277723drumbles
dubbins12358803dubbins
duchies133312313duchies
duckies143613813duckies
dummies123012133dummies
durries83817353durries
duties74921903du_ties
fogies104118063fog_ies
freebies1337873freebies
fuddies123211203fuddies
fuggier12348963fuggier
fuggiest13228813fuggiest
fugios1037583fug_ios
fugles104715783fug_les
fugues104511683fug_ues
fumbles143514413fumbles
funnies104113603funnies
furies95126373fu_ries
gabies93820733_gabies
gibes84422523__gibes
gies55641423__g_ies
gobies95418063_gobies
grubbier13344753grubbier
grubbiest1434253grubbiest
grumbles13288873grumbles
guggles103410543guggles
gullies84717313gullies
gunnies83413123gunnies
guppies123310523guppies
gurries83515953gurries
gussies82813303gussies
hobbies143813343hobbies
hogties112813993hogties
humbles143215803humbles
hunkies143214503hunkies
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
huskies143212083huskies
hussies103213293hussies
jaggies163311083jaggies
jubes145420743ju_b_es
jubiles16289373ju_biles
juggles164510843juggles
jumbles183013323jumbles
junkies183711693junkies
juries134120633ju_ries
jutties143814003jutties
kebbies1537253kebbies
krubis1235003kru_bi_s
lambies113015113lambies
lobbies113612463lobbies
loobies93814103loobies
lubes74727993lu_b_es
luckies133313683luckies
luges65928753lug__es
luggie8318903luggie_
lunies64723013lu_nies
magpies12310363magpies
moggies113111723moggies
muddies113513953muddies
muggees11338883muggees
muggier11288943muggier
muggiest12228533muggiest
muggins11248073muggins
muhlies1238933muhlies
mumbles133014433mumbles
mummies103812843mummies
murries94118673murries
muskies133614673muskies
newbies12147423newbies
nubbier11308133nubbier
nubbiest12117313nubbiest
nubbins11268023nubbins
nubbles113412433nubbles
nubias8310093nu_bias
nudies75217093nu_dies
numbles113814273numbles
orgies72316093org_ies
outbids1098913outbids
outlies72421993outlies
outvies102214243outvies
piggies113813483piggies
pigmies122610993pigmies
pogies94123543pog_ies
pubes94423403pu_b_es
pubis94616473pu_bi_s
puggier11309383puggier
puggiest12219223puggiest
puggries12166383puggries
pugrees10218523pugrees
punkies134216803punkies
punties94520783punties
puppies103212613puppies
pussies93615693pussies
putties94420023putties
pygmies15205673pygmies
qubits173710353qu_bits
queries16315873queries
rabbins112811343rabbins
rabbis102613163rabbi_s
rabbits11299863rabbits
rabbles113517973rabbles
ragbags1135113ragbags
ragees74618663rag_ees
rages64539443rag__es
raggees93710913raggees
raggles93813283raggles
ragis66325603rag_i_s
ragtimes1135823ragtimes
rallies73823343rallies
rambles113118313rambles
ramies84630463r_amies
randies84225663randies
readies83324713readies
rebbes10313533r_ebbes
rebids94015533r_ebids
redries83721713redries
reflies104418533reflies
refries104419733refries
regains84316583regains
regales83520793regales
reges65628793reg__es
reggaes948883reggaes
regimes104514743regimes
regius7311923reg_ius
regives115014213regives
reglues838713reglues
reifies104218283reifies
relies65036423r_elies
replies94521043replies
reties65436193r_eties
retries74129073retries
ribbier1137593ribbier
ribbiest1237583ribbiest
ribes75530173r_ib_es
ribier84414233r_ibier
ribiers9319753r_ibiers
righties12711573righties
roadies83317443roadies
robbins112811063robbins
robes75133303r_ob_es
robins83617453r_obins
robles85321693r_obles
rogues74617673rog_ues
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
roubles93413513roubles
rouges76022383roug__es
rowdies113112693rowdies
rubaces1139313rubaces
rubbed114515083ru_bbed
rubber104715793ru_bber
rubbers113913193rubbers
rubbing123412273rubbing
rubbings13306333rubbings
rubbish1436303rubbish
rubbishes1644303rubbishes
rubble104315673rubble_
rubbled124611623rubbled
rubblier1244913rubblier
rubbliest1354693rubbliest
rube65532013ru_b_e_
rubel75416833ru_b_el
rubels84112993ru_bels
rubigo935053ru_bigo
rubigos1033653ru_bigos
rubious938283ru_bious
ruble74521253ru_ble_
rubrics1177093rubrics
rubs66133493ru_b__s
rubus76415063ru_b_us
ruches114819583ru_ches
ruckles133414603ruckles
ruddier9338523ruddier
ruddiest10278543ruddiest
ruddles92813873ruddles
ruderies9311333ruderies
rudesbies1242083rudesbies
rues46044483ru___es
ruffes124112423ru_ffes
ruffles133512273ruffles
rugae65114763rug_ae_
rugate75813813rugate_
rugby11448133rugb__y
rugged94215383rug_ged
rugger84414513rug_ger
ruggers94612313ruggers
rugging102512763rugging
ruglike1236283ruglike
rugolas836373rugolas
rugosas844973rugosas
rugose737283rugose_
rugous739653rug_ous
rugs56033683rug___s
ruins55822033ru__ins
rules55234253ru__les
rulier65016353ru_lier
ruliest72816433ru_liest
rumbaed12287493rumbaed
rumbas102512013rumb_as
rumble103718813rumble_
rumbled124514593rumbled
rumbler113514113rumbler
rumblers123610743rumblers
rummier11309563rummier
rummiest12299353rummiest
rumples113313133rumples
rundles83214713rundles
runes55530223ru__nes
runkles114111943runkles
runnier74010113runnier
runniest82911203runniest
runtier73512853runtier
runtiest83014513runtiest
rupees8312573ru_pees
ruses56136583ru__ses
rushees103311953rushees
rushes94724363ru_shes
rushier103411973rushier
rushiest113312923rushiest
rustics9810733rustics
rustier74416363rustier
rustiest83116803rustiest
rustles73416413rustles
rutiles74315843rutiles
rutins63818393ru_tins
ruttier73412283ruttier
ruttiest82712663ruttiest
scabies11613333scabies
snuggies10246363snuggies
sulkies114315763sulkies
sullies74122233sullies
tabbies112913503tabbies
tobies84521023_tobies
toughies1278243toughies
trilbies1037693trilbies
trusties82712853trusties
tubbier11237743tubbier
tubbiest12117293tubbiest
tubes74826453tu_b_es
tugriks1233153tugriks
tumbles113816023tumbles
tummies113012033tummies
tunnies73614263tunnies
turbines1039903turbines
turbits969233turbits
tushies10312163tushies
tutties73216473tutties
uglier748953_uglier
ugliest8410153_ugliest
umbles103817493_umbles
undies73821963_undies
unties64326923_unties
urbias839093_urbias
urges64619913urg__es
veggies1237553veggies
vegies104314273veg_ies
vuggier12296813vuggier
vuggiest13216923vuggiest
wussies103411083wussies
yabbies14279643yabbies
yummies14359533yummies
yuppies14339263yuppies
zombies2037993zombies

Search took 7 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.406440125.6
2DLD Change Limit1340273556.00022337.8
3Display Results3553550.1262817.5
 (SQL Overall)1786913556.53227356.2
 
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.