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

234 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
dumbest123874(None) 
numbest1138791numbest
bummest13298622bummest
dampest12411042dampest
dimmest1249252dimmest
drumbeat1343972drumbeat
dullest8312632dullest
dumbed124012082dumbe_d
dumber114414172dumbe_r
dumbness1334612dumbness
dumbos114111082dumbos_
dumbs105915752dumb_s_
dumpiest1338742dumpiest
dunnest83312262dunnest
fumiest12312192fumiest
humblest15288282humblest
rummest11279832rummest
armrest9310163armrest
auldest839893auldest
best66355323___best
bombast1348223bombast
bombes124916823bombes_
buffest15298643buffest
bumbles134016843bumbles_
bumboat1349023bumboat
bumpiest1437873bumpiest
busiest93716303busiest
cambist13312113cambist
combes125321733combes_
combust1338363combust
crumbiest1536253crumbiest
cubes95028163cu_bes_
cubist104214443cu_bist
cumber124016703cumbe_r
cumbers134515413cumbers
curtest9713963curtest
cutest85820143cu_test
daftest11248943daftest
dames85435853dam_es_
damndest1276003damndest
dankest122611673dankest
darkest122512623darkest
daubes94913703daubes_
daubiest1138233daubiest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
decumbent1644703decumbent
deepest10310443deepest
deffest14308803deffest
deftest112611713deftest
demast9517063dem_ast
dement93825143dem_ent
demes86032693dem_es_
demies94825803demies_
demurest1137453demurest
densest83112473densest
detest74122843d_etest
devest104418703d_evest
dewiest11312343dewiest
diciest103316523diciest
digest84019623d_igest
dimes85833043dim_es_
dimness1038843dimness
direst75024243d_irest
divest106820073d_ivest
doest65829523d__oest
domes85735563dom_es_
doomiest112910453doomiest
dopiest103315993dopiest
dotiest83717453dotiest
dourest8312943dourest
doziest174012473doziest
drabbest13295663drabbest
drest65530343d__rest
driest74722753d_riest
drumbeats1442323drumbeats
drumbles13277723drumbles_
drumliest1235433drumliest
drunkest1334423drunkest
dryest104811123d_ryest
dualist8614053dualist
dubbed124113213dubbe_d
dubber113814553dubbe_r
dubbers124011823dubbers
dubs78432193du_b_s_
duces86327473du_ces_
duchess1335553duchess
duckiest153211863duckiest
dudes75424373du_des_
duelist8511413duelist
dueness82310123dueness
dues56045503du__es_
duet56446263du__e_t
duets65323883du__ets
dukes105023473du_kes_
dulcet9314493dulce_t
dulcets1046283dulcets
dulness8307983dulness
dulses73913653dulses_
dumas85420433dum_as_
dumb97124103dumb___
dumbbell1542143dumbbell
dumbhead17102743dumbhead
dumbing13319853dumbing
dumbly14399603dumb_ly
dumbo105614063dumb__o
dummies123012133dummies_
dumped123814493dumpe_d
dumper114615213dumpe_r
dumpers123412663dumpers
dumpish15116113dumpish
dumps105220103dum_ps_
dunces95215753dunces_
dunes65332173du_nes_
dungiest102810743dungiest
dunness8298983dunness
dupes86425933du_pes_
dures65635923du_res_
duress74712063du_ress
durmast1037623durmast
durndest1065763durndest
durst66125173du__rst
duskiest133710083duskiest
dust57142533du___st
dustiest93015073dustiest
duties74921903duties_
duvet9321873du_ve_t
duvets1039223du_vets
elmiest9310743elmiest
fabbest1438033fabbest
fullest10313343fullest
fumbles143514413fumbles_
fumes105224703fum_es_
fumet105630223fum_e_t
fumets114311813fum_ets
funest94316863fu_nest
funfest13348083funfest
funnest102912003funnest
gambes116318313gambes_
gamest94919923gam_est
gamiest102816223gamiest
glummest13235563glummest
grummest13286363grummest
guest65225923gu__est
gumboot1246493gumboot
gumbos114610873gumbos_
gumless10228273gumless
gummiest13269023gummiest
homiest124116633homiest
hugest10311763hu_gest
humanest1348123humanest
humbles143215803humbles_
humpiest1538963humpiest
jambes175914053jambes_
jimpest18297553jimpest
jubes145420743ju_bes_
jumbles183013323jumbles_
jumbos17379123jumbos_
jumpiest1936863jumpiest
justest1449893justest
lambast11129893lambast
lambent113711303lambent
lambert113617113lambert
lambiest122410183lambiest
lamest84722763lam_est
limbiest12258893limbiest
limiest93716103limiest
limpest113712313limpest
lubes74727993lu_bes_
lumber103817773lumbe_r
lumbers113815913lumbers
lumpiest1239253lumpiest
luniest73516993luniest
lushest103312283lushest
mumbles133014433mumbles_
murkest133110203murkest
mutest84218053mu_test
nimblest1236923nimblest
nubbiest12117313nubbiest
nudest74113833nu_dest
numbat10312083numb_at
numbats1137673numbats
numbed114111443numbe_d
number103913223numbe_r
numbers113711243numbers
numbles113814273numbles_
numbness1234413numbness
numbs94913093numb_s_
plumiest122110293plumiest
plummest14276413plummest
plumpest14236353plumpest
pubes94423403pu_bes_
puniest92918093puniest
punkest132611693punkest
purest84021933pu_rest
quest144121323qu__est
rimiest93215853rimiest
rubes74928413ru_bes_
rubiest92914423rubiest
rudest74016313ru_dest
ruliest72816433ruliest
rumbas102512013rumbas_
rumbles114018393rumbles_
rummiest12299353rummiest
spumiest1238203spumiest
suavest10310623suavest
subset83122583su_bset
subtest9513963subtest
suggest9310863suggest
sumless92611123sumless
sumoist9311613sumoist
sunbelt939233sunbelt
surest65026763su_rest
tamest85721293tam_est
tempest1139223tempest
tubbiest12117293tubbiest
tubes74826453tu_bes_
tubist83013163tu_bist
tumbles113816023tumbles_
tumbleset1345373tumbleset
umbel93612843_umbe_l
umbels104510593_umbels
umber94617593_umbe_r
umbers104215213_umbers
umbles103817493_umbles_
umbos94613073_umbos_
unbelt83015693_unbelt
unbent83216593_unbent
unblest9411813_unblest
unrest62918853_unrest
upbeat10911513_upbeat
wombiest1536893wombiest
yummiest15256723yummiest

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 Limit1340272346.31321230.3
3Display Results2342340.0932516.1
 (SQL Overall)1786912346.81226231.8
 
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.