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

360 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
averting12251273(None) 
adverting1437221adverting
alerting91312381alerting
averring12239061averring
everting122213131everting
abetting1158292abetting
aborting11710252aborting
advecting1645112advecting
aerating92821002a_erating
agenting1039382agenting
airting83616302a_irting
amercing1337192amercing
asserting1038662asserting
avenging1345862avenging
averaging1446502averaging
aviating12311022aviating
caveating1539292caveating
caverning1536282caverning
cavorting1536062cavorting
diverting142410332diverting
exerting162211152exerting
havering152211052haver_ing
inverting131013222inverting
obverting1536302obverting
overing111918052over_ing
reverting132315132reverting
venting114218092_venting
verging123812302_verging
versing112314192_versing
vesting114618682_vesting
vetting114216562_vetting
wavering152410542waver_ing
abating10413973a_bating
abegging1334483abegging
ablating11312003ablating
aborning1188003aborning
absenting1236993absenting
abutting1137003abutting
accenting1487823accenting
accepting1695813accepting
accreting1446333accreting
accruing1344033accruing
acerbating1546293acerbating
acetin8314693ace_tin_
acetins9313173ace_tins
acierating1348323acierating
acting95920983a__cting
adapting1236643adapting
adeeming1254793adeeming
adhering1338883adher_ing
adopting1237453adopting
adoring9412523ador_ing
adorning1087323adorning
advertent1356593advertent
advertise1346103advertise
advertising16143613advertising
advertize2245383advertize
advertizing25144303advertizing
affecting1845233affecting
ageing84213403age__ing
agentings1134443agentings
agisting1038243agisting
agreeing10295903agreeing
airing74927503a_ir_ing
airthing12297953a_irthing
alarming1138583alarming
altering91917123alter_ing
amending12308913amending
anearing9413973anearing
aneling82719503ane_ling
angering102113803anger_ing
anteverting1544343anteverting
anting75827023a__nting
arcing95819643a__rcing
arming94719803a__rming
arresting1038633arresting
asperating1349563asperating
aspersing1237603aspersing
assenting1038163assenting
assorting1037303assorting
attesting1036383attesting
attriting1048693attriting
auditing1039033auditing
availing1267283availing
averment13311603averment
aversion1147313aversion
aversions1247053aversions
aversive1447443aversive
avert86029493avert___
averted112211613avert_ed
averter102410553avert_er
averters11249513averters
avertible1495233avertible
averts95715243avert__s
avoiding1336783avoiding
avowing1466603av_owing
avulsing1234433avulsing
awaiting1238273awaiting
awarding1356043awarding
aweing103911253awe__ing
beating104326873_beating
beavering1538703beaver_ing
belting104119133_belting
berating113220763_berating
berming123614833_berming
berthing14209603_berthing
besting104923923_besting
betting103921403_betting
bleating113514503bleating
blurting11258773blurting
capering132414963caper_ing
carting104228283_carting
caseating12311743caseating
catering112019913cater_ing
cering94522533_cer_ing
charting142614193charting
cheating144014523cheating
clavering1538373claver_ing
cleating113518143cleating
clefting14347583clefting
clerking15257163clerking
coercing1349003coercing
converting16313133converting
courting112514573courting
covering142215723cover_ing
coveting141912303cove_ting
creating113921953creating
cresting114017043cresting
darting94020663_darting
davening13258873dave_ning
denting94422183_denting
derating103222283_derating
deserting11713143deserting
devesting14249903devesting
devoting1338823devoting
dieting93616833die_ting
diverging15226693diverging
divesting14298483divesting
dueting93814393due_ting
duetting1047183duetting
eating75134403__eating
egesting1039013egesting
ejecting18268163ejecting
electing112113783electing
emerging1237893emerging
erecting112415063erecting
erring73816483__erring
evening11310223eve_ning
everything2042363everything
evicting1437483evicting
eviting11511373ev_iting
experting1938053experting
exserting1736663exserting
faceting1438783face_ting
facetting1535283facetting
farting114120753_farting
favoring1596673favor_ing
felting113515213_felting
feting104417793_fe_ting
fetting113517873_fetting
fevering152510083fever_ing
fleeting122910323fleeting
flirting12319013flirting
fretting122711523fretting
gaveling133410163gave_ling
gavelling14286883gavelling
gavotting1443193gavotting
gazetting2043243gazetting
getting93316563_getting
girting93113333_girting
gleeting10279173gleeting
governing1435533governing
greeting103112353greeting
guesting1058463guesting
harvesting1744413harvesting
havening15258553have_ning
hearting12513123hearting
heating114024323_heating
hefting144510913_hefting
henting113719653_henting
herding122915123_herding
herring113615883_herring
hovering151911143hover_ing
hurting113914033_hurting
ideating10311703ideating
inserting10914243inserting
inventing13109973inventing
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
investing13119393investing
iterating10314253iterating
jeering153513043jeer_ing
jerking19308923_jerking
jesting154317713_jesting
jetting153815343_jetting
karting123716063_karting
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
kvelling16146513kvelling
lacerating1349453lacerating
lagering102212313lager_ing
lamenting1237703lamenting
laveering1336813laveering
layering122310353layer_ing
leering83417643leer_ing
letting83218533_letting
levering122212503lever_ing
livering122012383liver_ing
macerating1549543macerating
marting103325013_marting
meeting103314963_meeting
melting103317753_melting
merging112711763_merging
meriting11314693_meriting
meting94320593_me_ting
metring103215293_metring
nerving112910833_nerving
nesting84320443_nesting
netting84018763_netting
operating12313723operating
overacting16310913overacting
overawing16710293overawing
overbig13237543overbi_g
overdoing1439143overdoing
overeating141016533overeating
overhang15248863overhang
overhating17910953overhating
overhung15235623overhung
overkind1637953overkind
overlong1238123overlong
overlying1638003overlying
overmine13313663overmine
overrating14814203overrating
overswing1638453overswing
overtaking1878893overtaking
overtaxing2157693overtaxing
overthin1438533overthin_
overthink1945843overthink
overtime131312273overtime
overtiming1699073overtiming
overtip1238193overti_p
overtips1338353overtips
overtire111413113overtire
overtiring141210203overtiring
overtone111012573overtone
overturing1499413overturing
overusing1339043overusing
overvoting1747533overvoting
overwind1538533overwind
papering132213313paper_ing
parenting12611583parenting
parting103527383_parting
patenting1248943patenting
peering103520353peer_ing
pelting102917273_pelting
perking143716463_perking
perming123416093_perming
perverting1646623perverting
petting103720953_petting
piercing1346663piercing
pleating112916053pleating
porting103021783_porting
quavering2235953quaver_ing
querying2135243querying
questing1838273questing
quirting18238383quirting
raveling123414373rave_ling
ravelling13269253ravelling
ravening122611293rave_ning
reesting93118273reesting
renting84026853_renting
resting85031183_resting
retting83425883_retting
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
revesting132814123revesting
revetting132912633revetting
revoting12312033revoting
riveting12139443rive_ting
rivetting13256413rivetting
sabering112113743saber_ing
savoring1269483savor_ing
scarting113415263scarting
scenting113212813scenting
seating84130683_seating
serging93416673_serging
sering74731813_ser_ing
serving113014983_serving
setting83621393_setting
severing122013853sever_ing
sheeting122712833sheeting
shirting123213613shirting
shorting122514803shorting
skirting13289393skirting
slavering1338723slaver_ing
sleeting93114163sleeting
smarting113212453smarting
smelting11339713smelting
smerking15258473smerking
snorting92613373snorting
sorting83221813_sorting
spirting112913633spirting
sporting112415463sporting
spurting113111633spurting
starting93116173starting
sterling93615553sterling
stetting93410713stetting
subverting1666293subverting
sweating123213023sweating
sweeting123911313sweeting
swerving1546113swerving
tabering112211423taber_ing
tapering112112503taper_ing
tarting84222653_tarting
tenting84621153_tenting
terming104016003_terming
testing86021053_testing
tiering8315253tier_ing
traversing1444803traversing
travertine1345413travertine
treating92519613treating
tweeting12267033tweeting
unerring9311273unerring
vacating14310363vacating
valeting1238853valeting
varying1429723_varying
vatting113614853_vatting
vaulting12227233vaulting
vaunting12338753vaunting
vealing114217423_vealing
veering113213683_veering
vegging13308873_vegging
veiling113615293_veiling
veining114713893_veining
vending124015263_vending
venging123710943_venging
verdin103113023_verdin_
verdins112812333_verdins
vermin113414523_vermin_
versine102515173_versine
vertigo1146133_vertigo
vestings12359143_vestings
vetoing11309053_vetoing
vexing17479173_ve_xing
voting103916033_v_oting
wafering15208893wafer_ing
wagering13219523wager_ing
watering122316323water_ing
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wetting114117383_wetting
whetting1535973whetting
wresting123811833wresting
yerking15368813_yerking
zeroing1738343_zeroing
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.456391866.2
2DLD Change Limit1461623607.51319454.5
3Display Results3603600.1861935.5
 (SQL Overall)1786913608.15521911.8
 
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.