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

166 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
rhus7511405(None) 
rhos76319061rhos
thus76721471thus
ahis76135382ahis
ahs68644822ah_s
amus65529612amus
anus47131112anus
arcus76918862arcus
argus66716542argus
bhut95425712bhut
bhuts105812952bhuts
bus56950972_bus
chis95933312chis
chub115516412chub
chubs125412622chubs
chug105914112chug
chugs115511942chugs
chum116318002chum
chums125015832chums
crus65828482crus
ecus65421462ecus
emus66821682emus
feus75830752feus
flus75626542flus
ghis85020162ghis
gnus56518002gnus
has67372652_has
hes66654202_hes
his66359502_his
hos68364192_hos
hub86437482_hub
hubs96027142_hubs
hue66642302_hue
hues75235232_hues
hug76037362_hug
hugs86129752_hugs
huh96432012_huh
hum85542932_hum
hums96831422_hums
hun65844712_hun
huns76136932_huns
hup86437812_hup
hush105224112_hush
husk116021952_husk
hut66457292_hut
huts76737442_huts
jehus15488572jehus
jus106930222_jus
khis117017982khis
mhos95517772mhos
mus55946752_mus
nous46136982nous
nus37939392_nus
ohms95514032ohms
ohs66232312oh_s
onus45826812onus
opus66420592opus
phis95724902phis
phut96925972phut
phuts104613502phuts
plus66324832plus
prahus11458242prahus
praus74621752praus
pus55547842_pus
rads56046602rads
rags55448372rags
rais45252622rais
rakus94413672rakus
rams65950772rams
ramus76418282ramus
raps66247732raps
ras37575392r_as
rats46260372rats
raws75238212raws
rays77642352rays
rebs65733562rebs
rebus75721112rebus
recs65734182recs
reds56042862reds
rees45364192rees
refs75732242refs
regs55436572regs
reis45343232reis
rems66237722rems
reps65937952reps
res35565042r_es
rets45352562rets
reuse56025362reuse
revs75027052revs
rhea75017432rhea
rheas84816952rheas
rhesus936202rhesus
rheum1038842rheum
rheums1135462rheums
rho65924832rh_o
rhumb12438652rhumb
rhumbs13366772rhumbs
rhuses94911792rhuses
rias45540592rias
ribs65833022ribs
rids56539552rids
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rins46153192rins
rips66237432rips
risus54216392risus
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954142roes
roms67038962roms
rots46454092rots
roue45941742roue
roues56039352roues
roup66627692roup
roups75118902roups
rouse56634702rouse
roust55532062roust
rout46153282rout
routs57133412routs
roux117419362roux
rows75941752rows
rub56342822r_ub
rubs66133492rubs
rubus76415062rubus
rue35549262r_ue
rues46044482rues
rug46039152r_ug
rugs56033682rugs
rum56644642r_um
rums64833472rums
run36244992r_un
runs46438082runs
ruse45938932r_use
rush76628182r_ush
rusk85823312r_usk
rust45544912r_ust
rut35560522r_ut
ruts44541492ruts
ryas77224612ryas
ryes75529352ryes
shes75734352shes
shul75823152shul
shuls85319712shuls
shun75122772shun
shuns85018142shuns
shush113812542shush
shut76137592shut
shuts85622482shuts
sous46947212sous
taus46342732taus
this76027382this
thous86017262thous
thud85613912thud
thuds95110132thuds
thug86415482thug
thugs95611992thugs
ulus45622562ulus
urus46426142urus
us26937432__us
vaus75928922vaus
whup125714162whup
whups134210002whups
whys137011662whys
yous76230652yous

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298721660.79637527.6
3Display Results1661660.0305533.3
 (SQL Overall)1786911661.109161128.0
 
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.