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

176 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
rheumy143335(None) 
rheum1038841rheum_
rheums1135461rheums
rheme106214052rhe_me
rheumic1443542rheumic
rhumb12438652rh_umb
ahem97225363ahe_m_
beamy126218573_beamy
chammy18488953chammy
chasmy16468543chasmy
cheeky18448613cheeky
cheery144913153cheery
cheesy14419193cheesy
chemo12313633che_mo
cherry144810763cherry
cherty144612473cherty
chesty144610503chesty
chevy16479993che_vy
chewy165011903che_wy
chromy16309903chromy
chum116318003ch_um_
chummy18385893chummy
chump145315443ch_ump
chums125015833ch_ums
creamy134811363creamy
demy105422853_de_my
dreamy12509993dreamy
elmy95616793__elmy
emmy116013243__emmy
enemy1059993ene_my
fleury12417353fleury
fumy127118583__fumy
gemmy135211053_gemmy
germy115113663_germy
geum75424553_geum_
geums85414113_geums
gleamy12398113gleamy
gremmy1454473gremmy
hammy155113433_hammy
haulmy14455553_haulmy
heady125117263_heady
heapy135914983_heapy
heaume1137543_heaume
heavy144814183_heavy
hedgy134510753_hedgy
hefty146112133_hefty
helm95530023_helm_
helms105619463_helms
hem86148733_he_m_
heme95034413_he_me
hemp115725623_he_mp
hempy154912763_hempy
hems95534943_he_ms
henry114014473_henry
herby134715313_herby
herm95636153_herm_
herma105318883_herma
herms105626433_herms
herry114922473_herry
heuch135312333_heuch
heugh125410923_heugh
hey96741063_he__y
homy126623223_h_omy
hum85542933_h_um_
hump116228723_h_ump
humpy155115673_h_umpy
hums96831423_h_ums
ileum74512823ileum_
jemmy19498553_jemmy
khoum1476643khoum_
khoums1594013khoums
neum66723083_neum_
neume74414403_neume
neums75414253_neums
odeum84610543odeum_
odeums9367313odeums
oleum73613323oleum_
oleums8358783oleums
phlegmy1841503phlegmy
plumy124213233_plumy
pneuma1035263pneuma
rammy124312493r_ammy
ready94821503r_eady
ream65841613r_eam_
reams75729623r_eams
rebury11349213rebury
rebuy104714683r_ebuy
redly94217203r_edly
redry94314363r_edry
reechy14367823reechy
reedy910020293r_eedy
reefy114217703r_eefy
reeky125416263r_eeky
refly113914563r_efly
refry114412463r_efry
regma84612333r_egma
rehem103815353rehem_
rehems113410983rehems
rehung1036343rehung
reify114814973r_eify
rekey124014733r_ekey
relay84424673r_elay
relume8313273relume
rely75428953r_e_ly
rem56150043r_e_m_
rems66237723r_e_ms
repay104818453r_epay
reply104015853r_eply
repump1235683repump
resay85320543r_esay
resume8313783resume
retry84718083r_etry
reuse56025363r_euse
rhea75017433rhe__a
rheas84816953rhe_as
rhebok1534613rhebok
rhemes115913183rhemes
rhenium1246243rhenium_
rheniums1344413rheniums
rhesus936203rhesus
rhetor938063rhetor
rheumier1342513rheumier
rhomb12399803rh_omb
rhumba13375553rh_umba
rhumbs13366773rh_umbs
rhus75114053rh_u_s
rhyme13479553rh_yme
rimy96621283r__imy
roomy107118063r_oomy
roupy106112713r_oupy
ruby97819943r__uby
ruly76323143r__uly
rum56644643r__um_
rummy124212413r_ummy
rump86729083r__ump
rums64833473r__ums
seamy105921273_seamy
shammy16388503shammy
sheeny124912193sheeny
shelly124414473shelly
shelty124011553shelty
shelvy15377863shelvy
sherry124510413sherry
sheuch14267043sheuch
sheugh13295883sheugh
shimmy16306413shimmy
shlump1345713shlump
shlumpy1742863shlumpy
spumy124610363_spumy
steamy115112373steamy
stemmy13417033stemmy
them97427043the_m_
theme105921733the_me
theory121098363theory
therm106018023therm_
therme115814993therme
therms115914873therms
theurgy1442733theurgy
thewy146311853the_wy
they107223753the__y
thrum104713633thrum_
thrummy1742173thrummy
thrums11429123thrums
thumb124511283th_umb
thump126211573th_ump
thymy16437923th_ymy
whammy19375293whammy
wheezy24244523wheezy
whelky19314973whelky
whelm134611983whelm_
whelms14377573whelms
wherry15477333wherry
whey135018713whe__y
wheyey1834323wheyey
whump154910043wh_ump
yeuky15547033_yeuky

Search took 8 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 Filter1786911127160.406440125.6
2DLD Change Limit1127161766.78316617.4
3Display Results1761760.0463826.1
 (SQL Overall)1786911767.23524698.1
 
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.