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

366 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
duetting104718(None) 
dueting93814391due_ting
abetting1158292abetting
betting103921402_betting
butting103519282bu_tting
curetting1236572curetting
cutting103817492cu_tting
denting94422182d_enting
dieting93616832die_ting
dotting93314482d_otting
dratting10389662dratting
ducting113713592du_cting
dueling93614542due_ling
duelling103410732duelling
duettist945512duettist
dunting93418382du_nting
dusting93618992du_sting
fetting113517872_fetting
fretting122711522fretting
getting93316562_getting
guesting1058462guesting
gutting93415922gu_tting
hutting113016032hu_tting
jetting153815342_jetting
jutting153313712ju_tting
letting83218532_letting
netting84018762_netting
nutting83316232nu_tting
petting103720952_petting
putting103218572pu_tting
questing1838272questing
quitting18228832quitting
retting83425882_retting
rutting82718042ru_tting
setting83621392_setting
stetting93410712stetting
tutting83515912tu_tting
vetting114216562_vetting
wetting114117382_wetting
whetting1535972whetting
abutting1137003abutting
admitting1345033admitting
adulating1178723adulating
advecting1645113advecting
adverting1437223adverting
agenting1039383agenting
alerting91312383alerting
auditing1039033auditing
autoing8314043au_toing
averting122512733averting
batting104422273_batting
beating104326873_beating
beetling1139283beetling
begetting13186583begetting
belting104119133_belting
besetting12268423besetting
besting104923923_besting
bitting103717293_bitting
blatting114111653blatting
bleating113514503bleating
blotting113910433blotting
bunting103718833bu_nting
bursting1138703bursting
busting104221793bu_sting
bustling112110063bustling
butling103516813bu_tling
catting103922643_catting
chatting142810143chatting
cheating144014523cheating
cleating113518143cleating
clefting14347583clefting
clotting113110643clotting
coquetting2244513coquetting
creating113921953creating
cresting114017043cresting
cueing94913613cue__ing
cuittling1234103cuittling
curating11314293curating
curvetting1643393curvetting
cuttings11277613cu_ttings
cuttling1138203cuttling
darting94020663d_arting
dartling1039563dartling
dating85326483d__ating
daunting103310403daunting
dauting93814763d_auting
dawting123610673d_awting
dealing94323233d_ealing
deaning94020473d_eaning
deaving123814753d_eaving
debating123213733debating
debiting122511203debiting
debuting12268633debuting
decking153915593d_ecking
deeding103315123d_eeding
deeming113913123d_eeming
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
defying15328823d_efying
deicing11312193d_eicing
dejecting20217793dejecting
dekeing13358353d_ekeing
deking125614553d_e_king
delating103119603delating
deleing93313953d_eleing
deleting103314423deleting
delving123711573d_elving
dementing13311043dementing
demitting13239073demitting
demoing11311753d_emoing
demoting12311423demoting
denning93515173d_enning
denoting10311753denoting
dentin73919573d_entin_
dentine83320243d_entine
dentins83419223d_entins
denying123711293d_enying
deputing12238793deputing
derating103222283derating
deratting1139513deratting
deserting11713143deserting
destine83719953d_estine
destiny113111463d_estiny
detain74617383d_etain_
detains83716093d_etains
detecting13259983detecting
detesting112610323detesting
detoxing1736313d_etoxing
deucing1139393d_eucing
devesting14249903devesting
devoting1338823devoting
dewing114115703d_e_wing
dictating1338883dictating
dieing84018653die__ing
digesting12208673digesting
dighting142510843dighting
dilating102714913dilating
diluting10248983diluting
dinting93520553d_inting
dipnetting1453623dipnetting
directing1338823directing
dirtying1336093dirtying
dittoing1036263dittoing
diverting142410333diverting
divesting14298483divesting
doating93816863d_oating
donating10311803donating
doting84821913d__oting
doubting1237373doubting
drafting13339413drafting
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dre_eing
dressing102810423dressing
drifting13338733drifting
dubbing133311213du_bbing
ducking154315053du_cking
duckling16247703duckling
ductings12346673du_ctings
duding93913323du__ding
duetted937023duett_ed
duettists1043043duettists
duking124715133du__king
dulling93418273du_lling
dumbing13319853du_mbing
dummying17263723dummying
dumping133712913du_mping
dumpling14217893dumpling
dunging103012623du_nging
dunking133813263du_nking
dunning93514473du_nning
duping104113633du__ping
dupping133711043du_pping
during84419403du__ring
durning93511733du_rning
dusking133912053du_sking
dustbin1044543dustbin_
dustbins1144593dustbins
dustings10419033du_stings
duvetine1245163duvetine
dwelling13368413dwelling
dyeing11428213dye__ing
eating75134403__eating
educating1337933educating
egesting1039013egesting
ejecting18268163ejecting
electing112113783electing
emitting112410353emitting
erecting112415063erecting
everting122213133everting
exerting162211153exerting
facetting1535283facetting
fatting113818703_fatting
felting113515213_felting
feting104417793_fe_ting
fettling1266773_fettling
fitting113516563_fitting
flatting123511253flatting
fleeting122910323fleeting
flitting123010883flitting
fritting123510703fritting
fueling113615133fue_ling
fuelling123410153fuelling
futzing20307903fu_tzing
gazetting2043243gazetting
ghettoing1442123ghettoing
gitting93215703_gitting
gleeting10279173gleeting
glutting10247643glutting
greeting103112353greeting
gritting10309983gritting
guessing1036243guessing
gusting93917163gu_sting
guttling1037293guttling
hatting113920233_hatting
heating114024323_heating
hefting144510913_hefting
henting113719653_henting
hitting113017273_hitting
hotting113116523_hotting
hunting114317123hu_nting
hurting113914033hu_rting
hurtling12318313hurtling
hustling12228793hustling
ideating10311703ideating
inletting1087873inletting
insetting1079283insetting
jesting154317713_jesting
jettying1933953_jettying
jotting152912773_jotting
justing153615163ju_sting
justling16207253justling
juttying1933573juttying
kitting123214443_kitting
knitting13257023knitting
knotting13236573knotting
lotting82917753_lotting
lunting83817743lu_nting
lusting83619323lu_sting
lustring9269723lustring
luting75221753lu__ting
luxating1645613luxating
matting103620143_matting
meeting103314963_meeting
melting103317753_melting
meting94320593_me_ting
metring103215293_metring
mulcting13246983mulcting
munting103718773mu_nting
musting103221073mu_sting
mutating112211753mutating
muting93921523mu__ting
naething1236073naething
nesting84320443_nesting
nettings9288103_nettings
nettling957213_nettling
nutating92411953nutating
nuttings9276783nu_ttings
omitting11217743omitting
oughting1335953oughting
ousting84021353ou_sting
outeating10814493outeating
outing74128153ou__ting
outring84021023ou_tring
outsing83320463ou_tsing
patting103722343_patting
pelting102917273_pelting
pettings11349703_pettings
pettling1168213_pettling
pipetting1435513pipetting
pitting103618873_pitting
platting114813033platting
pleating112916053pleating
plotting113011013plotting
potting103720893_potting
prettying1536043prettying
punting103318443pu_nting
pupating1337683pupating
puttying1434953puttying
putzing19359123pu_tzing
quanting1849233quanting
queening1846113queening
queering1838203queering
quelling18259793quelling
querying2135243querying
queueing1842873queueing
queuing1736233que_uing
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quoiting1836093quoiting
quoting17310043qu_oting
ratting83822363_ratting
reesting93118273reesting
reletting102713943reletting
renting84026853_renting
resetting102816293resetting
resting85031183_resting
retying113213833_retying
revetting132912633revetting
rewetting132710443rewetting
rivetting13256413rivetting
rotting82919683_rotting
rouletting1144753rouletting
russetting1184253russetting
rusting83821263ru_sting
rustling9249983rustling
scatting113311813scatting
scenting113212813scenting
seating84130683_seating
seething1239023seething
settings93810073_settings
settling978943_settling
sheeting122712833sheeting
shitting123212663shitting
shotting123012383shotting
shutting12309693shutting
sitting83519633_sitting
slatting94014233slatting
sleeting93114163sleeting
slitting93012583slitting
slotting92612613slotting
smelting11339713smelting
smutting11278063smutting
spatting113111763spatting
spitting113012323spitting
spotting112812093spotting
squatting1934513squatting
stotting92811163stotting
subletting1346273subletting
sueding92613753sue_ding
suiting83419003su_iting
swatting12309593swatting
sweating123213023sweating
sweeting123911313sweeting
swotting12268483swotting
tatting84019523_tatting
teething1237163teething
tenting84621153_tenting
testing86021053_testing
totting82816843_totting
treating92519613treating
trotting92510913trotting
tufting11289873tu_fting
turtling9238833turtling
tweeting12267033tweeting
twitting12307223twitting
uniting8315823_uniting
unsetting1088993unsetting
untying1138943_untying
upsetting1275563upsetting
vatting113614853_vatting
venting114218093_venting
vesting114618683_vesting
vetoing11309053_vetoing
wadsetting1542913wadsetting
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wettings12348403_wettings
witting113417063_witting
wotting112913843_wotting
wresting123811833wresting
zesting174515333_zesting

Search took 9 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 Filter1786911461620.483369960.7
2DLD Change Limit1461623668.11018022.4
3Display Results3663660.1562346.2
 (SQL Overall)1786913668.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.