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

325 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
exerting16221115(None) 
everting122213131everting
experting1938051experting
exserting1736661exserting
alerting91312382alerting
averting122512732averting
coexerting2045492coexerting
deserting11713142deserting
egesting1039012egesting
ejecting18268162ejecting
electing112113782electing
emerging1237892emerging
erecting112415062erecting
exacting1838522exacting
exalting1638032exalting
excepting2145872excepting
excerpting2244142excerpting
exciting1838022exciting
excreting1946432excreting
execrating2047882execrating
executing1945582executing
exempting2144222exempting
exertion15310082exertion
exertions1639762exertions
exertive1839082exertive
exhorting2045732exhorting
existing1639072existing
exiting15311392ex_iting
expecting2146692expecting
exporting1937322exporting
exsecting1935932exsecting
extorting1746762extorting
exulting1637642exulting
reverting132315132reverting
abetting1158293abetting
aborting11710253aborting
adverting1437223adverting
aerating92821003_aerating
agenting1039383agenting
airting83616303_airting
amercing1337193amercing
asserting1038663asserting
averring12239063averring
beating104326873_beating
begetting13186583begetting
belting104119133_belting
berating113220763_berating
berming123614833_berming
berthing14209593_berthing
besetting12268423besetting
besting104923923_besting
betting103921403_betting
bleating113514503bleating
blurting11258773blurting
carting104228283_carting
cementing1438763cementing
cering94522533_cer_ing
charting142614193charting
cheating144014523cheating
cleating113518133cleating
clefting14347583clefting
clerking15257163clerking
coercing1349003coercing
courting112514573courting
creating113921953creating
cresting114017043cresting
darting94020663_darting
deaerating12311563deaerating
decerning1337293decerning
defeating142311973defeating
defecting162510223defecting
deferring1436143deferring
degerming1435753degerming
dehorting1447213dehorting
dejecting20217793dejecting
deleting103314423dele_ting
dementing13311043dementing
demerging1436643demerging
demeriting1448683demeriting
denting94422183_denting
departing1349513departing
deperming1537113deperming
deporting1369593deporting
derating103222283_derating
deserving1497903deserving
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
devesting14249903devesting
dieting93616833die_ting
diverting142410333diverting
dueting93814393due_ting
duetting1047183duetting
earing75235483e_ar_ing
earning83418213e_arning
earring83519013e_arring
earthing12310323e_arthing
easting84924303e_asting
eating75134403__eating
editing9313133e_diting
effecting1845583effecting
elating83423083e_lating
elevating1338203elevating
eluting84115293e_luting
embruing1344523embruing
embruting1444283embruting
emending12298893emending
emetin8613463eme_tin_
emetine9712943eme_tine
emetins9812643eme_tins
emitting112410353emitting
emoting10313563e_moting
enacting11311363enacting
enditing10311073enditing
enervating1488433enervating
enserfing1345893enserfing
entering91920053enter_ing
enuring8813883enur_ing
equating18310113equating
erring73816483__erring
eructing112110173eructing
erupting11218443erupting
escorting1237713escorting
escoting1158713escoting
eserine7415903eser_ine
estating92614993estating
evening11310223eve_ning
everything2042353everything
evicting1437483evicting
eviting11511373e_viting
exceeding2043493exceeding
excelling1935643excelling
excessing1945713excessing
exciding1935923exciding
excising1837213excising
excusing1836503excusing
exercise1747063exercise
exercising2044453exercising
exert124624143exert___
exerted152210053exert_ed
exerts133712293exert__s
exhaling1936293exhaling
exhuming2143303exhuming
exiling15311083ex_iling
exing136016813ex___ing
exonerating1945553exonerating
expediting2144643expediting
expelling1936133expelling
expending2045933expending
expensing1946003expensing
expertise1847933expertise
expertism2045433expertism
expertize2746583expertize
expertizing3044623expertizing
expiating1938543expiating
expiring1836253expiring
exposing1836673exposing
exsertile1644593exsertile
exsertion1646853exsertion
exsertions1746743exsertions
extending1835853extending
extermine1848283extermine
extracting2047223extracting
extruding1844333extruding
exuberating2144173exuberating
exuding16347443ex_uding
eyeing10429363eye__ing
farting114120753_farting
federating1548853federating
felting113515213_felting
ferreting13127693ferreting
feting104417793_fe_ting
fetting113517873_fetting
fevering152510083fever_ing
fleeting122910323fleeting
flirting12319013flirting
fretting122711523fretting
generating12310383generating
getting93316563_getting
girting93113333_girting
gleeting10279173gleeting
greeting103112353greeting
guesting1058463guesting
hearting12513123hearting
heating114024323_heating
hefting144510913_hefting
henting113719653_henting
herding122915123_herding
herring113615883_herring
hurting113914033_hurting
ideating10311703ideating
inserting10914233inserting
inverting131013223inverting
iterating10314253iterating
jeering153513043jeer_ing
jerking19308923_jerking
jesting154317713_jesting
jetting153815343_jetting
karting123716063_karting
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
leering83417643leer_ing
letting83218533_letting
levering122212503lever_ing
marting103325013_marting
meeting103314963_meeting
melting103317753_melting
merging112711763_merging
meriting11314683_meriting
metering112915633meter_ing
meting94320593_me_ting
metring103215293_metring
nemertine1147073nemertine
nerving112910823_nerving
nesting84320443_nesting
netting84018763_netting
obverting1536303obverting
operating12313723operating
overing111918053over_ing
parting103527383_parting
peering103520353peer_ing
pelting102917273_pelting
perking143716463_perking
perming123416093_perming
perverting1646623perverting
petering112516813peter_ing
petting103720953_petting
piercing1346663piercing
pleating112916053pleating
porting103021783_porting
querying2135243querying
questing1838273questing
quirting18238383quirting
reesting93118273reesting
refecting152413353refecting
referring1338033referring
reheating132314913reheating
rejecting192211153rejecting
relenting102716773relenting
reletting102713943reletting
remeeting12311433remeeting
remelting12311703remelting
remerging1358323remerging
renesting102514703renesting
renting84026853_renting
repeating122618983repeating
repenting122316553repenting
reperking1638703reperking
reporting12513903reporting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
reserving131110643reserving
resetting102816293resetting
resorting10614613resorting
resting85031183_resting
retesting102614603retesting
retorting10613273retorting
retting83425883_retting
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
revesting132814123revesting
revetting132912633revetting
rewetting132710443rewetting
rezeroing1935933rezeroing
scarting113415263scarting
scenting113212813scenting
seating84130683_seating
secerning1246203secerning
secreting1279823secreting
selecting12310533selecting
serging93416673_serging
sering74731813_ser_ing
serving113014983_serving
setting83621393_setting
severing122013853sever_ing
sewering122411093sewer_ing
sheeting122712833sheeting
shirting123213613shirting
shorting122514803shorting
skirting13289393skirting
sleeting93114163sleeting
smarting113212453smarting
smelting11339713smelting
smerking15258473smerking
snorting92613373snorting
sorting83221813_sorting
spirting112913633spirting
sporting112415463sporting
spurting113111633spurting
starting93116173starting
sterling93615553sterling
stetting93410713stetting
sweating123213023sweating
sweeting123911313sweeting
swerving1546113swerving
tarting84222653_tarting
tenting84621153_tenting
terming104016003_terming
testing86021053_testing
tiering8315253tier_ing
treating92519613treating
tweeting12267033tweeting
unerring9311273unerring
veering113213683veer_ing
venerating14410053venerating
venting114218093_venting
verging123812303_verging
versing112314193_versing
vesting114618683_vesting
vetting114216563_vetting
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wetting114117383_wetting
whetting1535973whetting
wresting123811833wresting
xeroxing1534513_xeroxing
yerking15368813_yerking
zeroing1738343_zeroing
zesting174515333_zesting

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.1531167915.0
2DLD Change Limit1461623257.34619896.8
3Display Results3253250.1232642.3
 (SQL Overall)1786913257.62223444.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.