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

249 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
rumbaed1228749(None) 
rhumbaed1672751rhumbaed
rumbled124514591rumbled
bumbled144113042bumbled
crumbed14378472crumb_ed
crumbled15357442crumbled
drumbled14266032drumbled
dumbed124012082dumb_ed
fumbled153710492fumbled
grumbled14256752grumbled
humbled153711812humbled
jumbled19379962jumbled
mumbled143010762mumbled
numbed114111442numb_ed
rambled123913512rambled
rubbed114515082ru_bbed
rubbled124611622rubbled
rubied94312402ru_bied
rumba93612512rumba__
rumbas102512012rumba_s
rumble103718812rumble_
rumbler113514112rumbler
rumbles114018392rumbles
rummaged1443272rummaged
rumored1046642rumored
rumpled123810012rumpled
sambaed1238302sambaed
tumbled123412242tumbled
ambled115116353_ambled
armband1265983armband
aubade939223au_bade
bombard1437333bombard
bombed134113873bomb_ed
brambled15316723brambled
brumbies1436533brumbies
bubbled113612123bubbled
buboed113010003bu_boed
bulbed114312773bulb_ed
bumble124216893bumble_
bumbler134013233bumbler
bumbles134016843bumbles
bummed134211723bum_med
bumped134414003bum_ped
burbled124312673burbled
combated1539823combated
combed135516543comb_ed
crumber13339643crumb_er
crumbier1456363crumbier
crumble133410403crumble_
crumbles14329683crumbles
crumped144311223crum_ped
crumpled15296873crumpled
cubed105519703cu_b_ed
cumber124016703cumb_er
cumbered15157953cumbered
curbed114615873curb_ed
drubbed13406983dru_bbed
drumbeat1343973drumbeat
drumble12337893drumble_
drumbles13277723drumbles
drumhead1542653drumhead
drummed13306323drum_med
dubbed124113213du_bbed
dumber114414173dumb_er
dumbhead17102743dumbhead
dummied13346723dummied
dumped123814493dum_ped
embayed1535443_embayed
embed105014293_emb_ed
fubbed144711243fu_bbed
fumble133214263fumble_
fumbler143610813fumbler
fumbles143514413fumbles
fumed116118823fum__ed
gambade1336383gambade
gambled134112163gambled
gimbaled14104173gimbaled
grubbed13406433gru_bbed
grumble12349233grumble_
grumbler13866683grumbler
grumbles13288873grumbles
grumped13337333grum_ped
gumball1266833gumball
gummed123811663gum_med
gumweed1433943gumweed
humble133615053humble_
humbler143411943humbler
humbles143215803humbles
hummed144812673hum_med
humored1336723humored
humped144015243hum_ped
humphed1835423humphed
husband1345653husband
huzzaed1943103huzzaed
imbed105013633_imb_ed
imbued1136153_imbued
jambed184811403jamb_ed
jumbal1758463jumba_l
jumbals18106533jumbals
jumble174012653jumble_
jumbler183910273jumbler
jumbles183013323jumbles
jumped183511553jum_ped
lambed115614783lamb_ed
limbed114513173limb_ed
lubed85319893lu_b_ed
lumbago1243833lumbago
lumbar103610593lumba_r
lumbars11289763lumbars
lumber103817773lumb_er
lumbered13188233lumbered
lumped114216963lum_ped
mamboed14417623mamboed
mumble123614343mumble_
mumbler133510913mumbler
mumbles133014433mumbles
mummed104411553mum_med
mummied11327103mummied
mumped133813163mum_ped
numbat10312083numba_t
numbats1137673numbats
number103913223numb_er
numbered13147143numbered
numbles113814273numbles
outbaked1538393outbaked
outbred10311263outbred
plumbed14317273plumb_ed
pumiced1435173pumiced
pumped133915563pum_ped
rabbled123514423rabbled
ramble104519973ramble_
rambler113313263rambler
rambles113118313rambles
rammed113117303ram_med
rampaged1434103rampaged
ramped114617903ram_ped
rebated103619693r_ebated
rebred95816353r_ebred
remade94316983rem_ade
remand95618963rem_and
remated103522473remated
remised103516843remised
remixed173510743remixed
removed134611313removed
rhumba13375553rhumba__
rhumbas14305163rhumba_s
ribald9209293r_ibald
riband9239623r_iband
ribband1245583ribband
ribbed114014373r_ibbed
rimed84826373rim__ed
rimland1035663rimland
rimmed114812303rim_med
rimpled123311423rimpled
roband92310723r_oband
robbed113415193r_obbed
robed85323733r_ob_ed
romped114513653rom_ped
rubace10310173ru_bace
rubaces1139303ru_baces
rubati8299693ru_bati
rubato8319673ru_bato
rubber104715793ru_bber
rubbered1335383rubbered
rubbies114114113rubbies
rubble104315673rubble_
rubbles113715113rubbles
rubboard1343973rubboard
rube65532013ru_b_e_
rubel75416833ru_b_el
rubes74928413ru_b_es
rubier84814733ru_bier
rubies84420333ru_bies
ruble74521253ru_ble_
rubles83921703ru_bles
ruched124314633ru_ched
rucked134718763ru_cked
ruckled144111033ruckled
ruddled103010873ruddled
rued55729793ru___ed
ruffed134312743ru_ffed
ruffled14369153ruffled
rugae65114763ru_gae_
rugbies10339353rugbies
rugged94215373ru_gged
ruinated939523ruinated
ruined74813323ru_ined
ruled65822523ru__led
rumaki1235133rum_aki
rumbaing13185303rumbaing
rumblers123610743rumblers
rumbly134412163rumb_ly
rumen74419503rum__en
ruminated1258663ruminated
rummage1234583rummage
rummager1343593rummager
rummages1344933rummages
rummer104715483rum_mer
rummier11309563rummier
rummies113212793rummies
rumoured1143783rumoured
rumple103913013rumple_
rumples113313133rumples
runback1556603runback
runkled12399013runkled
rurban849043rurba_n
rushed104419863ru_shed
rusted75020923ru_sted
rustled83311323rustled
rutted74518403ru_tted
scubaed1236123scubaed
scumbled1535053scumbled
stumbled1335623stumbled
subbed114116673su_bbed
summae103911013summae_
summand1236263summand
summated13298833summated
summed114014043sum_med
sunbaked1545533sunbaked
surbased1136613surbased
thumbed15336173thumb_ed
tombed113812133tomb_ed
trembled1335243trembled
truebred1142753truebred
trumped12439713trum_ped
tubae74716643tu_bae_
tubbed114712223tu_bbed
tubed85818043tu_b_ed
tumble103215643tumble_
tumbler113412823tumbler
tumbles113816023tumbles
tumbrel11406853tumbrel
tumped114216233tum_ped
turbaned1145623turbaned
umbel93612833_umb_el
umbeled12208193_umbeled
umber94617583_umb_er
umbered121510113_umbered
umbles103817483_umbles
umbrae1038673_umbrae_
umped104717273_um_ped
unbaked143312893_unbaked
unbaled103315963_unbaled
unbased103513483_unbased
unbated103317733_unbated
unbred92613303_unbred
wambled153610753wambled
wimbled15298143wimbled
wombed14419233womb_ed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272497.53017799.1
3Display Results2492490.0932677.4
 (SQL Overall)1786912497.77922970.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.