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

138 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
rhumba1337555(None) 
rhumb12438651rhumb_
rhumbas14305161rhumbas
rhumbs13366771rhumbs
rumba93612511r_umba
rhomb12399802rhomb_
rhombi13365202rhombi
rhombs13336492rhombs
rhumbaed1672752rhumbaed
rumbas102512012r_umbas
thumb124511282thumb_
thumbs13377442thumbs
ahimsa1134783ahimsa
alumna857343alumna
brumby15385953brumby
bubba84311803_bubba
chimb144813563chimb_
chimbs153910303chimbs
chimla1337593chimla
chub115516413chu_b_
chubby1844123chubby
chubs125412623chu_bs
chufa13489113chu_fa
chukka1433013chukka
chum116318003chum__
chummy18385893chummy
chump145315443chum_p
chumps154313823chumps
chums125015833chum_s
chuppa1543973chuppa
crumb114313593crumb_
crumbs12409233crumbs
crumby15408113crumby
cumbia12379893_cumbia
dhurna1043563dhurna
douma85817703doum_a
duma75524453_dum_a
dumb97124103_dumb_
dumbo105614063_dumbo
dumbs105915753_dumbs
dumka12438833_dumka
gamba106018513_gamba
gumbo104413583_gumbo
gumma105313103_gumma
hamza19139773_hamza
hub86437483_hu_b_
hubby155011403_hubby
hubs96027143_hu_bs
hula74923753_hu_la
hum85542933_hum__
human102716033_human
humble133615053_humble
humbly164010523_humbly
humbug1434803_humbug
humic124113243_humic
humid114213763_humid
humor101110513_humor
hump116228723_hum_p
humph155712213_humph
humps126322803_humps
humpy155115673_humpy
hums96831423_hum_s
humus106215073_humus
huzza1646093_huzza
juba134916983_ju_ba
jumbal1758463_jumbal
jumbo164311073_jumbo
limba95414983_limba
louma76213633loum_a
luma65527523_lum_a
lumbar103610593_lumbar
macumba1573043macumba
mamba116317523_mamba
numb85520613_numb_
numbat10312083_numbat
numbs94913093_numbs
plumb114514073plumb_
plumbs12459333plumbs
puma85424123_pum_a
rambla103510933r_ambla
regma84612333regm_a
remuda936823remuda
rhea75017433rh__ea
rheme106214053rhem_e
rhemes115913183rhemes
rheum1038843rheum__
rheumic1443543rheumic
rheums1135463rheum_s
rheumy1433353rheum_y
rhombic16264533rhombic
rhombus14243893rhombus
rhubarb1442173rhu_barb
rhumbaing1742243rhumbaing
rhus75114053rhu__s
rhuses94911793rhuses
rhyme13479553rhym_e
rhymed15416713rhymed
rhymer14387083rhymer
rhymes14419823rhymes
rhyta1135083rh_yta
ruana5312423r_uana
rub56342823r_u_b_
rubby124413863r_ubby
rube65532013r_u_be
rubs66133493r_u_bs
ruby97819943r_u_by
ruga56121233r_u_ga
rugby11448133r_ugby
rum56644643r_um__
rumbaed12287493r_umbaed
rumble103718813r_umble
rumbly134412163r_umbly
rumen74419503r_umen
rumina83412483r_umina
rummy124212413r_ummy
rumor71011323r_umor
rump86729083r_um_p
rumps95922293r_umps
rums64833473r_um_s
rurban849043r_urban
samba95618773_samba
scuba94211593scu_ba
scumbag1443573scumbag
suba64926603_su_ba
summa94713313_summa
thuja1535213thu_ja
thulia936113thulia
thumbed15336173thumbed
thump126211573thum_p
thumps13449353thumps
thuya1135583thu_ya
trauma838803traum_a
tsuba745563tsu_ba
tuba65422363_tu_ba
umbo85516663__umbo
umbra948513__umbra
whump154910043whum_p
whumps16427093whumps

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161385.67319868.9
3Display Results1381380.0304600.0
 (SQL Overall)1786911386.09329327.3
 
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.