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

396 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
duetted93702(None) 
dueted84113591due_ted
abetted1058322abetted
betted94721162_betted
butted94722062bu_tted
curetted1137172curetted
dented84120512d_ented
dieted83115492die_ted
dotted84717522d_otted
dratted9358592dratted
ducted104012122du_cted
dueled84813662due_led
duelled9359752duelled
dunted84718502du_nted
dusted83918372du_sted
fetted104817892_fetted
fretted113411852fretted
guested9157712guested
gutted84716362gu_tted
hutted104616332hu_tted
jetted143915082_jetted
jutted144315022ju_tted
letted74118542_letted
netted74118712_netted
nutted74316972nu_tted
petted94121522_petted
putted94220252pu_tted
quested17168382quested
quitted17339892quitted
retted74826312_retted
rutted74518402ru_tted
stetted82610402stetted
tutted75117442tu_tted
vetted104316322_vetted
wetted103717022_wetted
whetted14256692whetted
abetter958323abetter
abutted1056983abutted
acetated112010683acetated
admitted1234763admitted
adulated1039753adulated
advected1534533advected
adverted1336103adverted
agented939423agented
alerted82512223alerted
audited939033audited
aurated83817793aurated
autoed7712823au_toed
averted112211613averted
batted95623653_batted
beetled1038213beetled
belted94020633_belted
bested94922753_bested
better84723703_better
bitted94418483_bitted
blatted104812713blatted
bleated104015973bleated
blotted103911833blotted
bunted95219183bu_nted
burette939853burette_
burettes1048953burettes
bursted1039423bursted
busted95123153bu_sted
bustled104011513bustled
butled94818603bu_tled
butte74924293bu_tte_
butter84724233bu_tter
buttes84822563bu_ttes
catted95422473_catted
chatted133411893chatted
cheated134416343cheated
chested133811673chested
cleated103417843cleated
clefted13326753clefted
clotted104011823clotted
coquetted2154823coquetted
created104323453created
crested103416533crested
cuittled1133993cuittled
cuneated11310103cuneated
curated104717583curated
curette939783curette_
curettes1039313curettes
curvetted1543703curvetted
cutter84521003cu_tter
cuttled10319933cuttled
cuvette1235833cuvette_
cuvettes1335323cuvettes
darted84620923d_arted
dartled9409853dartled
dated75530993d__ated
daunted93810193daunted
dauted84114933d_auted
dawted11489683d_awted
deaned84620453d_eaned
deaved114916553d_eaved
debated113916083debated
debited113311623debited
debuted11379333debuted
decked145217623d_ecked
deed65340903d_e__ed
deeded94615543d_eeded
deemed104713063d_eemed
defatted1335673defatted
defeated132812163defeated
defected15289973defected
defied115016383d_efied
defter104215923d_efter
deiced104214483d_eiced
dejected19307593dejected
deked115718533d_e_ked
delated93722873delated
deled75326543d_e_led
deleted93314913deleted
delved114112753d_elved
demented12311273demented
demitted12288773demitted
demoed103713443d_emoed
demoted114313543demoted
denied84318633d_enied
denned84215633d_enned
denoted93512763denoted
dentated10411703dentated
deputed114610173deputed
derated93623503derated
deratted1048403deratted
deserted101012203deserted
detected12289733detected
deter65028043d_e_ter
detested10279623detested
detoxed1636103d_etoxed
deuced104112123d_euced
devested13239133devested
devoted124111093devoted
dewed105020303d_e_wed
dexter143810893d_exter
dictated1239203dictated
diester83013683diester
dieter73516773die_ter
diether1147443diether
digested11208163digested
dighted132511493dighted
dilated93115823dilated
diluted9248933diluted
dinette8310013dinette_
dinettes9310193dinettes
dinted84419843d_inted
dipnetted1343353dipnetted
directed1238233directed
dirtied93210853dirtied
dittoed936733dittoed
diverted13199583diverted
divested13268213divested
doated84118183d_oated
doited85016633d_oited
donated93513863donated
doted75227073d__oted
dottel73610893d_ottel
dotter74419343d_otter
doubted11307483doubted
drafted12439033drafted
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346893dredged
dreed75222843dre__ed
dressed93511873dressed
drifted12367953drifted
dubbed124113213du_bbed
ducked144718013du_cked
duded84417133du__ded
dueler74213683due_ler
dueller8329833dueller
duende836923duende_
duendes938193duendes
duet56446263due_t__
dueting93814393dueting
duets65323883due_t_s
duetting1047183duetting
duettist945513duettist
duked115218463du__ked
dulled84719423du_lled
dumbed124012083du_mbed
dummied13346723dummied
dumped123814493du_mped
dunged95414693du_nged
dunite7315013dunite_
dunites8313593dunites
dunked124315283du_nked
dunned85015523du_nned
duped95118323du__ped
dupped124411643du_pped
dured75025403du__red
durned84113173du_rned
dusked124112513du_sked
duster74919723du_ster
dustier83814133dustier
dustmen1035773dustmen
duties74921903du_ties
dwelled12337593dwelled
dyeweed1543203dyeweed
educated1237943educated
egested938123egested
ejected17297653ejected
elected102812613elected
emitted103010853emitted
erected103213993erected
everted112711853everted
exerted152210053exerted
facetted1445743facetted
fatted105419843_fatted
felted103714653_felted
feted94420933_fe_ted
fetter94120383_fetter
fettled11378933_fettled
fitted104716663_fitted
flatted114012943flatted
fleeted113310233fleeted
flitted114011643flitted
fouette1038213fouette_
fouettes1137883fouettes
fretter103412753fretter
fritted113611333fritted
fueled104913603fue_led
fuelled11369193fuelled
fumette1245523fumette_
fumettes1345773fumettes
futzed19418983fu_tzed
gazetted19234853gazetted
getter74117613_getter
ghettoed1342083ghettoed
gitted84015053_gitted
gleeted9379323gleeted
glutted937243glutted
greeted93111383greeted
gritted94110903gritted
guessed9176603guessed
gusted84316723gu_sted
guttated10266873guttated
gutter73817713gu_tter
guttled9378993guttled
hatted104921513_hatted
heated104525593_heated
hefted134911423_hefted
hented104218753_hented
hotted104319943_hotted
hunted104417013hu_nted
hurtled11339593hurtled
hustled113210133hustled
ideated9310973ideated
insetted9249023insetted
jested144416503_jested
jettied15366973_jettied
jotted143615173_jotted
justed144215773ju_sted
justled15338093justled
juttied15417863juttied
kitted115114833_kitted
knitted12337423knitted
knotted12357233knotted
letter63722583_letter
lotted74222403_lotted
lunated8310823lunated
lunette737483lunette_
lunettes836753lunettes
lunted74517523lu_nted
lusted74319443lu_sted
lustred8359053lustred
luted64826143lu__ted
luxated1535713luxated
matted94521413_matted
meated94222403_meated
melted94219063_melted
meted85424433_me_ted
metred95315143_metred
mettled103510543_mettled
mulcted12296693mulcted
musette938433musette_
musettes1037433musettes
musted93321073mu_sted
mutated102712253mutated
muted85023383mu__ted
mutter84418883mu_tter
nested74720063_nested
netter63722023_netter
nettled8339943_nettled
nutated83113423nutated
nutter63918053nu_tter
omitted10347893omitted
oughted1236223oughted
ousted73720583ou_sted
outed65429063ou__ted
outled74020343ou_tled
patted94724683_patted
pelted94617763_pelted
petter83924773_petter
pettled103611513_pettled
pipetted1335263pipetted
pitted94319593_pitted
platted103614263platted
pleated103816633pleated
plotted104612373plotted
potted94624013_potted
prettied1159253prettied
punted94618713pu_nted
pupated12319353pupated
puttee85919723pu_ttee
putter83921443pu_tter
puttied103811163puttied
putzed18409113pu_tzed
quanted1738963quanted
queened17105863queened
queered17117213queered
quelled17279273quelled
queried1738683queried
quester161410023quester
queued16336943que_ued
quieted17309723quieted
quilted17319313quilted
quirted17369213quirted
quitter162910753quitter
quoited1756403quoited
quoted16359453qu_oted
ratted74923343_ratted
reested82916233reested
rented74426593_rented
rested74430783_rested
retied75924983_retied
reutter71010093reutter
revetted122210943revetted
rewetted12228353rewetted
rivetted12226093rivetted
rotted74524433_rotted
rouletted1045053rouletted
rusted75020923ru_sted
rustled83311323rustled
scatted103512773scatted
scented102811883scented
seated75131063_seated
seethed113410193seethed
settee63721023_settee
setter64023723_setter
settled83210873_settled
sheeted113813043sheeted
shitted114212053shitted
shotted113912403shotted
slatted84015183slatted
sleeted83113223sleeted
slitted83513313slitted
slotted84613883slotted
smelted10399093smelted
smutted1037463smutted
sotted74121403_sotted
spatted104014143spatted
spitted103912703spitted
spotted103713143spotted
squatted1835343squatted
stotted83511423stotted
sueded84014633sue_ded
suited74019423su_ited
suttee63721543su_ttee
swatted114110693swatted
sweated113411543sweated
swotted11398713swotted
tatted74920533_tatted
teated74924023_teated
teethed11318623teethed
tented74221003_tented
tested74421523_tested
tetter64322453_tetter
totted74319953_totted
treated83618703treated
trotted83711283trotted
tufted10359283tu_fted
turtled8309683turtled
tutued7349413tu_tued
tweeted11336583tweeted
twitted11326633twitted
united74421543_united
unletted9310313unletted
untied73720813_untied
unwetted1238123unwetted
utter54218763_u_tter
vatted104214733_vatted
vented104617923_vented
vested104217353_vested
vetoed10359823_vetoed
vetter93417643_vetter
wadsetted1442623wadsetted
weeted103913793_weeted
welted103715823_welted
wetter93919443_wetter
whetter13348803whetter
witted104216813_witted
wotted104115713_wotted
wrested113410933wrested
zested164214043_zested

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.390458182.1
2DLD Change Limit1340273965.87622809.2
3Display Results3963960.1402828.6
 (SQL Overall)1786913966.40627894.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.