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

368 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
emitting11241035(None) 
demitting13239071demitting
omitting11217741omitting
remitting122412621remitting
admitting1345032admitting
befitting15236622befitting
bemisting1438072bemisting
bitting103717292_bitting
editing9313132edi_ting
emoting10313562em_oting
emptying1634242emptying
evicting1437482evicting
eviting11511372evi_ting
existing1639072existing
exiting15311392exi_ting
fitting113516562_fitting
flitting123010882flitting
fritting123510702fritting
gitting93215702_gitting
gritting10309982gritting
hitting113017272_hitting
imitating1238762imitating
kitting123214442_kitting
knitting13257022knitting
matting103620142_matting
milting103619122_milting
minting103020812_minting
misting103623382_misting
mitring103514142_mitring
permitting1546302permitting
pitting103618872_pitting
quitting18228832quitting
reemitting1346632reemitting
refitting132811122refitting
reminting122315102reminting
resitting103414872resitting
shitting123212662shitting
sitting83519632_sitting
slitting93012582slitting
smiting103014442smi_ting
smutting11278062smutting
spitting113012322spitting
twitting12307222twitting
witting113417062_witting
abetting1158293abetting
abutting1137003abutting
agisting1038243agisting
agitating1138863agitating
airting83616303_airting
aviating12311023aviating
baiting103918883bai_ting
batting104422273_batting
begetting13186583begetting
belittling1343193belittling
bemiring13239603bemi_ring
bemixing20226523bemi_xing
besetting12268423besetting
besmutting1553353besmutting
besotting12256873besotting
betting103921403_betting
biting95321823_bi_ting
bittings11339293_bittings
blatting114111653blatting
blitzing2035903blitzing
blotting113910433blotting
brittling1235543brittling
butting103519283_butting
catting103922643_catting
cementing1438763cementing
chatting142810143chatting
chitling142910663chitling
citing94220183_ci_ting
clotting113110643clotting
committing1746683committing
cuittling1234103cuittling
cutting103817493_cutting
debiting122511203debi_ting
defatting1436103defatting
delisting112710503delisting
demasting1338453demasting
dementing13311043dementing
demising122012523demi_sing
demoting12311423dem_oting
depicting1537813depicting
deratting1139513deratting
desisting112810383desisting
deviating14311083deviating
dieting93616833_dieting
dinting93520553_dinting
dittoing1036263_dittoing
dotting93314483_dotting
dratting10389663dratting
drifting13338733drifting
duetting1047183duetting
earthing12310333earthing
easting84924303e_asting
eating75134403e__ating
edifying1636083edifying
egesting1039013egesting
ejecting18268163ejecting
elating83423083e_lating
electing112113783electing
eliciting1237773eliciting
eliding93414343eli_ding
eluting84115293e_luting
emaciating1546823emaciating
emailing113010043emailing
emanating1239003emanating
embattling1542193embattling
embaying1635263embaying
embittering1642943embittering
embowing1636243embowing
embrittling1651623embrittling
embruing1344523embruing
embruting1444283embruting
emceeing1343573emceeing
emending12298893emending
emerging1237893emerging
emetin8613463em_etin_
emetine9712943em_etine
emetins9812653em_etins
emigrating1467503emigrating
emittance1343863emittance
emitted103010853emitt_ed
emitter93211083emitt_er
emitters10349643emitters
empaling1338363empaling
emptings1364823em_ptings
emptins1179403em_ptins
emulating1239873emulating
enacting11311363enacting
enditing10311073enditing
enisling949633enisling
enlisting1038343enlisting
enticing11311803enticing
entitling1037103entitling
epilating12310973epilating
equating18310113equating
erecting112415063erecting
eructing112110173eructing
erupting11218443erupting
escoting1158713escoting
estating92614993estating
everting122213133everting
evincing1446183evincing
exacting1838523exacting
exalting1638033exalting
exciting1838023exciting
exerting162211153exerting
exiling15311083exi_ling
expiating1938543expiating
exulting1637643exulting
fainting123312163fainting
faithing1537153faithing
fatting113818703_fatting
feinting123410833feinting
fetting113517873_fetting
fisting113818123_fisting
fittings12318203_fittings
flatting123511253flatting
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
foisting122910503foisting
fretting122711523fretting
gaiting93716583gai_ting
geminating1447763geminating
gemmating1576443gemmating
getting93316563_getting
gifting123810893_gifting
girting93113333_girting
gittin72910553_gittin_
glinting103210053glinting
glitzing1934973glitzing
glutting10247643glutting
grifting13299263grifting
gutting93415923_gutting
hatting113920233_hatting
heisting123411043heisting
hesitating1448003hesitating
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hoisting123610903hoisting
hotting113116523_hotting
hutting113016033_hutting
imputing1336853imputing
jetting153815343_jetting
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
jotting152912773_jotting
jutting153313713_jutting
kilting123213853_kilting
kithing153411553_kithing
kiting114117093_ki_ting
kitling123313573_kitling
kittling1336063_kittling
knittings14273453knittings
knotting13236573knotting
leniting9312353leni_ting
letting83218533_letting
levitating1446653levitating
lifting113313273_lifting
lilting83515383_lilting
limiting1138813limiting
linting83820983_linting
listing84020593_listing
lotting82917753_lotting
malting103219083_malting
marting103325013_marting
masting104325823_masting
mating94832913_m_ating
mattin84416633_mattin_
mattings11369673_mattings
mattins93316143_mattins
mediating13311203mediating
meditating1448123meditating
meeting103314963_meeting
melting103317753_melting
meriting11314693meriting
meting94320593_m_eting
metring103215293_metring
miching152911803_miching
miffing16298403_miffing
miking134218463_mi_king
milding113615453_milding
milking143712763_milking
milling103223683_milling
miming114317263_mi_ming
mincing123314333_mincing
minding113317893_minding
mining94225453_mi_ning
minuting1139723_minuting
miring93723803_mi_ring
missing103619073_missing
mitering113015403_mitering
mitten83914093_mitten_
mittens9349883_mittens
mixing164713943_mi_xing
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
munting103718773_munting
musting103221073_musting
mutating112211753_mutating
muting93921523_m_uting
netting84018763_netting
nutting83316233_nutting
opiating11410093opiating
painting113614423painting
patting103722343_patting
petting103720953_petting
pithing134014053_pithing
pittings11349123_pittings
pitying132910243_pitying
platting114813033platting
plotting113011013plotting
pointing112813683pointing
potting103720893_potting
printing113216083printing
putting103218573_putting
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
ratting83822363_ratting
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
retting83425883_retting
revetting132912633revetting
rewetting132710443rewetting
rifting113515003_rifting
rioting82716393_rioting
rotting82919683_rotting
rutting82718043_rutting
sainting93215733sainting
scatting113311813scatting
seriating10916403seriating
setting83621393_setting
shifting152910383shifting
shirting123213613shirting
shotting123012383shotting
shutting12309693shutting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sittings9339733_sittings
skirting13289393skirting
skiting123812503ski_ting
slatting94014233slatting
slotting92612613slotting
smarting113212453smarting
smelting11339713smelting
smiling103915443smi_ling
smirking15277233smirking
smitten936693smitten_
spatting113111763spatting
spirting112913633spirting
spiting103917623spi_ting
splitting1236563splitting
spotting112812093spotting
stetting93410713stetting
stilting93312403stilting
stinting93415743stinting
stotting92811163stotting
submitting1544973submitting
suiting83419003sui_ting
swatting12309593swatting
swotting12268483swotting
tainting93613583tainting
tatting84019523_tatting
tempting1357343tem_pting
tilting83417103_tilting
tinting84620603_tinting
tithing113513893_tithing
titling83715793_titling
toiting83217093toi_ting
totting82816843_totting
trithing122811773trithing
trotting92510913trotting
tutting83515913_tutting
twisting12427813twisting
unfitting1336423unfitting
uniting8315823uni_ting
unmitring1245263unmitring
unremitting1443213unremitting
unwitting1335583unwitting
vatting113614853_vatting
vetting114216563_vetting
vittling1236143_vittling
vomiting1437733vomi_ting
waisting123615213waisting
waiting113618953wai_ting
wetting114117383_wetting
whetting1535973whetting
whisting15329543whisting
whiting143311303whi_ting
whittling1634383whittling
wilting113515913_wilting
wisting113519743_wisting
withing143814493_withing
witing103522823_wi_ting
witling113215813_witling
wittings12328733_wittings
wotting112913843_wotting
writhing15278673writhing
writing113713893wri_ting

Search took 8 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.420425454.8
2DLD Change Limit1461623687.06320694.0
3Display Results3683680.1562359.0
 (SQL Overall)1786913687.63923391.9
 
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.