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

398 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
demoting1231142(None) 
demoing11311751demo_ing
denoting10311751denoting
devoting1338821devoting
emoting10313561_emoting
debating123213732debating
debiting122511202debiting
deboning12109152deboning
debuting12268632debuting
decocting1538122decocting
decoding132410052decoding
decoying15208762decoying
dehorting1447212dehorting
delating103119602delating
deleting103314422deleting
demasting1338452demasting
dementing13311042dementing
demising122012522demising
demitting13239072demitting
demobbing1743492demobbing
demotic12412332demoti_c
demotics1338752demotics
demotion1169072demotion
demotions1258442demotions
demotist11311842demotist
demounting1444962demounting
denting94422182de_nting
deponing121211212deponing
deporting1369592deporting
deposing12129772deposing
deputing12238792deputing
derating103222272derating
detoxing1736312detoxing
doting84821912d__oting
remating112322402remating
removing1439082removing
revoting12312032revoting
tempting1357342tempting
aerating92820993aerating
armoring1149123armoring
beating104326873be_ating
becoming1538163becoming
behoving1734913behoving
belting104119133be_lting
bemiring13239603bemiring
bemisting1438073bemisting
bemixing20226523bemixing
bemoaning1435953bemoaning
bemocking2034653bemocking
bemusing1336613bemusing
berating113220753berating
besmoking18114603besmoking
besotting12256873besotting
besting104923923be_sting
betting103921403be_tting
booting103821363_booting
cementing1438763cementing
coempting1636073coempting
compting153013603compting
coting94629253__coting
cremating14312183cremating
dadoing1038523dado_ing
damaging1337383damaging
damming133812743dam_ming
damning114211633dam_ning
damping133414003dam_ping
darting94020663d_arting
dating85326483d__ating
daunting103310403daunting
dauting93814763d_auting
dawting123610673d_awting
deaconing1337193deaconing
deairing10311893deairing
dealing94323233de_aling
deaning94020473de_aning
deashing134210953deashing
deaving123814753de_aving
debasing12238063debasing
decanting132510633decanting
decaying15239453decaying
deciding132210833deciding
decimating1648743decimating
decking153915593de_cking
decorating14312063decorating
decrying15237403decrying
deducing1336423deducing
deducting1436833deducting
deeding103315123de_eding
deeming113913123de_eming
defacing15238683defacing
defaming15238463defaming
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
defiling132812463defiling
defining133711803defining
deflating142610713deflating
defoaming1645653defoaming
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defrosting1544493defrosting
defusing13227933defusing
defuzing22195253defuzing
defying15328823de_fying
degusting1236163degusting
dehorning1455243dehorning
deicing11312193de_icing
deifying1637633deifying
deigning1137753deigning
dejecting20217793dejecting
dekeing13358353de_keing
deking125614553de__king
delaying133210973delaying
deleing93313953de_leing
deliming12310373deliming
delimiting1445843delimiting
delisting112710503delisting
delousing1136303delousing
deluding1137683deluding
deluging1137123deluging
delving123711573de_lving
demagoging1643193demagoging
demanding14237923demanding
demarking1736763demarking
demeaning1337243demeaning
demerging1436643demerging
demeriting1448683demeriting
demeton1037683demeton_
demetons1137623demetons
demolish1447833demolish
demon86520313demo__n_
demoniac1346873demoniac
demonian1147713demonian
demonic12311223demoni_c
demonise11411933demonise
demonising1447563demonising
demonism1359453demonism
demonist11413463demonist
demonize20311533demonize
demonizing2348853demonizing
demons94917723demo__ns
demote94817803demot__e
demoted114313543demot_ed
demotes104717673demot_es
demotists1247323demotists
demount1049743demo_unt
demurring1335253demurring
denning93515173de_nning
denotive1238673denotive
dentin73919573de_ntin_
dentine83320243de_ntine
dentins83419223de_ntins
denuding1137113denuding
denying123711293de_nying
departing1349513departing
depicting1537813depicting
depleting1378193depleting
deploring1337853deploring
deploying1636153deploying
depositing1446933depositing
deratting1139513deratting
deriding112512933deriding
deriving132510743deriving
derogating1348623derogating
desalting1138843desalting
deserting11713143deserting
desexing1736293desexing
desiring10312143desiring
desisting112810383desisting
desolating1239463desolating
desorbing1346363desorbing
despiting13179323despiting
destine83719953de_stine
destiny113111463de_stiny
detecting13259983detecting
detesting112610323detesting
detonating1248823detonating
detouring1136973detouring
deucing1139393de_ucing
develing133212733develing
devesting14249903devesting
deviating14311083deviating
deviling1311812853deviling
devising133111523devising
devoicing16145223devoicing
devolving1733983devolving
devotion1256763devotion
devotions1356593devotions
devouring1435953devouring
dewaxing20215293dewaxing
dewing114115703de__wing
dewooling1444323dewooling
deworming1635043deworming
dieting93616833d_ieting
dighting142510843dighting
dilating102714903dilating
diluting10248983diluting
dimming13339583dim_ming
dimpling14199023dimpling
dinting93520553d_inting
dittoing1036263dittoing
doating93816863d_oating
doing74923583d__o_ing
doling84923133d__oling
doming104218393d__oming
donating10311803donating
dooming113112533d_ooming
doping103919463d__oping
dosing83920273d__osing
dotting93314483d_otting
doubting1237373doubting
dowing114221513d__owing
dozing174214193d__ozing
drafting13339403drafting
dratting10389653dratting
drifting13338733drifting
droning93013723d_roning
drooling102610423drooling
drooping12268803drooping
droving12379683d_roving
ducting113713593d_ucting
dueting93814393d_ueting
duetting1047183duetting
dumbing13319843dum_bing
dummying17263723dummying
dumping133712913dum_ping
dumpling14217893dumpling
dunting93418383d_unting
dusting93618993d_usting
easting84924303_easting
eating75134403_e_ating
editing9313133_editing
elating83423083_elating
eloping103512833_eloping
eluting84115293_eluting
embowing1636243_embowing
emetin8613463_emetin_
emetine9712943_emetine
emetins9812643_emetins
emitting112410353_emitting
emodin9310353_emodin_
emodins1039433_emodins
emotion9711303_emotion
emotions10610283_emotions
emotive1239193_emotive
emptings1364813_emptings
emptins1179403_emptins
emptying1634243_emptying
eroding9314273_eroding
escoting1158713escoting
eviting11511373_eviting
evoking1536413_evoking
exempting2144223exempting
exiting15311393_exiting
fagoting1336283fagoting
feasting122011323feasting
feinting123410833feinting
felting113515213fe_lting
feting104417793fe__ting
fetting113517873fe_tting
footing115017593_footing
garoting10510703garoting
gelating103015733gelating
gemmating1576433gemmating
gemming13289143gem_ming
getting93316563ge_tting
hearting12513123hearting
heating114024323he_ating
hefting144510913he_fting
heisting123411043heisting
helmeting1545503helmeting
hematin121516013hematin_
hematine131614673hematine
hematins131714663hematins
hemming15269973hem_ming
henting113719653he_nting
hooting113919873_hooting
humoring1456853humoring
ideating10311703ide_ating
ingoting1039863ingoting
jemmying2332313jemmying
jesting154317713je_sting
jetting153815343je_tting
keynoting1742813keynoting
legating102313113legating
lemming12269393lem_ming
leniting9312353leniting
letting83218533le_tting
limiting1138813limiting
looting83019643_looting
mating94832913__mating
meeting103314963me_eting
melting103317753me_lting
meouing1059203me_ouing
meowing1368593me_owing
meriting11314673meriting
meting94320593__meting
moating104218153__moating
molting103517173__molting
mooing93718373__mooing
mooting103019363_mooting
moping114017103__moping
moving123913283__moving
mowing124119093__mowing
muting93921523__muting
negating102012833negating
nesting84320443ne_sting
netting84018763ne_tting
noting74120153__noting
osmosing1135223osmosing
pelting102917273pe_lting
pemoline12310273pemoline
permuting1446543permuting
petting103720953pe_tting
picoting1338883picoting
piloting1139693piloting
pivoting1436183pivoting
promoting1439913promoting
quoting17310043_quoting
reacting113317893reacting
rebating112418343rebating
rebooting12139023rebooting
reboring11312783reboring
reciting113118073reciting
recoating121317463recoating
recoding122213853recoding
redating102620173redating
redoing93516733redo_ing
reesting93118273reesting
refuting121911903refuting
relating92725443relating
remaking152613293remaking
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remising112516453remising
remitting122412623remitting
remixing182810333remixing
remolding1338163remolding
remotion10410233remotion
remotions1149703remotions
remounting1346673remounting
renting84026853re_nting
reporting12513903reporting
reposing111213803reposing
repotting12511123repotting
reputing112412603reputing
rerouting10311873rerouting
resiting93521123resiting
resoling92916303resoling
resorting10614613resorting
resowing123111523resowing
resting85031183re_sting
retorting10613273retorting
retting83425883re_tting
revoking1637803revoking
revolting1339633revolting
rezoning18310453rezoning
rioting82716393_rioting
rooting83522433_rooting
rumoring1136983rumoring
scooting113012633scooting
seating84130683se_ating
sedating103014113sedating
semolina1047493semolina
serotine8313563serotine
serotiny1148563serotiny
setting83621393se_tting
shooting122812843shooting
smelting11339713smelting
smiting103014443_smiting
smoking143210523_smoking
snooting92813193snooting
sooting82820953_sooting
temping122710693tem_ping
tenoning938893tenoning
tenting84621153te_nting
testing86021053te_sting
tooting83019423_tooting
toting74123793__toting
unmoving1436253unmoving
vamosing1435593vamosing
venoming1436403venoming
venting114218093ve_nting
vesting114618683ve_sting
vetoing11309053veto_ing
vetting114216563ve_tting
vomiting1437733vomiting
voting103916033__voting
weeting113816053we_eting
welting113615313we_lting
westing115020273we_sting
wetting114117383we_tting
xeroxing1534513xeroxing
yeasting12188923yeasting
zeroing1738343zero_ing
zesting174515333ze_sting

Search took 10 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.1731032896.0
2DLD Change Limit1461623989.14015991.5
3Display Results3983980.2361686.4
 (SQL Overall)1786913989.54918713.1
 
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.