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

192 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
demitting1323907(None) 
emitting112410351_emitting
remitting122412621remitting
admitting1345032admitting
befitting15236622befitting
bemisting1438072bemisting
debiting122511202debi_ting
defatting1436102defatting
delisting112710502delisting
demasting1338452demasting
dementing13311042dementing
demising122012522demi_sing
demoting12311422dem_oting
depicting1537812depicting
deratting1139512deratting
desisting112810382desisting
deviating14311082deviating
omitting11217742_omitting
permitting1546302permitting
reemitting1346632reemitting
refitting132811122refitting
reminting122315102reminting
resitting103414872resitting
begetting13186583begetting
belittling1343193belittling
bemiring13239603bemi_ring
bemixing20226523bemi_xing
besetting12268423besetting
besmutting1553353besmutting
besotting12256873besotting
betting103921403be__tting
bitting103717293__bitting
cementing1438763cementing
committing1746683committing
deairing10311893deai_ring
deaminating1547973deaminating
debating123213733de_bating
debuting12268633de_buting
decanting132510633decanting
deciding132210833deci_ding
decimating1648763decimating
decocting1538123decocting
dedicating1539143dedicating
deducting1436843deducting
defeating142311973defeating
defecting162510223defecting
defiling132812463defi_ling
defining133711803defi_ning
deflating142610713deflating
degusting1236163degusting
dehiscing1643733dehiscing
dehorting1447213dehorting
deicing11312193de_i_cing
deifying1637633de_ifying
deigning1137753de_igning
dejecting20217793dejecting
delating103119603de_lating
deleting103314423de_leting
delighting1644993delighting
deliming12310373deli_ming
delimiting1445843delimiting
demanding14237923demanding
demarking1736773demarking
demeaning1337243demeaning
demerging1436643demerging
demeriting1448683demeriting
demitted12288773demitt_ed
demobbing1743493demobbing
demoing11311753dem__oing
demounting1444963demounting
demurring1335253demurring
denitrating13128333denitrating
denoting10311753de_noting
denting94422183de__nting
depainting14156153depainting
departing1349513departing
depilating1439193depilating
depleting1378193depleting
deporting1369593deporting
deputing12238793de_puting
derating103222283de_rating
deriding112512933deri_ding
deriving132510743deri_ving
desalting1138843desalting
deserting11713143deserting
designing1236623designing
desiring10312143desi_ring
despiting13179323despiting
destining11311433destining
destituting13155163destituting
detecting13259983detecting
detesting112610323detesting
deticking1736043deticking
devesting14249903devesting
deviling1311812853devi_ling
devilling1436703devilling
devising133111523devi_sing
devoting1338823de_voting
dezincing2244183dezincing
dieting93616833d__ieting
dinting93520553d__inting
dittoing1036263d__ittoing
dominating1449403dominating
dotting93314483d__otting
dratting10389663d_ratting
drifting13338733d_rifting
duetting1047183d_uetting
editing9313133_edi_ting
emoting10313563_em_oting
emptying1634243_emptying
evicting1437483_evicting
eviting11511373_evi_ting
existing1639073_existing
exiting15311393_exi_ting
feinting123410833fe_inting
fetting113517873fe__tting
fitting113516563__fitting
flitting123010883_flitting
fritting123510703_fritting
geminating1447763geminating
gemmating1576443gemmating
getting93316563ge__tting
gitting93215703__gitting
gritting10309983_gritting
heisting123411043he_isting
hesitating1448003hesitating
hitting113017273__hitting
imitating1238763_imitating
jetting153815343je__tting
kitting123214443__kitting
knitting13257023_knitting
leniting9312353leni_ting
letting83218533le__tting
levitating1446653levitating
limiting1138813limi_ting
matting103620143__matting
mediating13311203mediating
meditating1448123meditating
meriting11314693meri_ting
milting103619123__milting
minting103020813__minting
misting103623383__misting
mitring103514143__mitring
netting84018763ne__tting
petting103720953pe__tting
pitting103618873__pitting
quitting18228833_quitting
readmitting1544053readmitting
rebutting1237523rebutting
reciting113118073reci_ting
recutting1239483recutting
reknitting1584993reknitting
reletting102713943reletting
relisting102414353relisting
remating112322423rem_ating
remeeting12311433remeeting
remelting12311703remelting
reminding132311543reminding
remising112516453remi_sing
remittent1148273remittent
remixing182810333remi_xing
repotting12511123repotting
resetting102816293resetting
resifting133512093resifting
resisting103215313resisting
resiting93521123resi_ting
resittings11264553resittings
retinting102215253retinting
retitling1039773retitling
retting83425883re__tting
revetting132912633revetting
rewetting132710443rewetting
seriating10916403seriating
setting83621393se__tting
shitting123212663_shitting
sitting83519633__sitting
slitting93012583_slitting
smiting103014443_smi_ting
smutting11278063_smutting
spitting113012323_spitting
splitting1236563splitting
submitting1544973submitting
tempting1357343tem_pting
twitting12307223_twitting
unfitting1336423unfitting
unmitring1245263unmitring
unremitting1443213unremitting
unwitting1335583unwitting
vetting114216563ve__tting
vomiting1437733vomi_ting
wetting114117383we__tting
witting113417063__witting

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411927.72019254.0
3Display Results1921920.0762526.3
 (SQL Overall)1786911928.24921662.1
 
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.