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

269 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
averring1223906(None) 
averting122512731averting
adverting1437222adverting
alerting91312382alerting
amercing1337192amercing
anearing9413972anearing
avenging1345862avenging
averaging1446502averaging
caverning1536282caverning
erring73816482__erring
everting122213132everting
havering152211052have_ring
herring113615882_herring
laveering1336812laveering
overing111918052ove_ring
unerring9311272unerring
veering113213682_veering
verging123812302_verging
versing112314192_versing
wavering152410542wave_ring
abegging1334483abegging
aberrant1049543aberrant
abetting1158293abetting
abhorring1543543abhorring
abjuring1834883abjuring
aborning1188003aborning
aborting11710253aborting
accruing1344033accruing
adeeming1254793adeeming
adhering1338883adhering
adjuring1735103adjuring
admiring1236133admiring
adoring9412523a_doring
adorning1087323adorning
advecting1645113advecting
aerating92821003a_erating
ageing84213403age__ing
agenting1039383agenting
agreeing10295903agreeing
airing74927503a__iring
airting83616303a_irting
alarming1138583alarming
alluring939073alluring
altering91917113altering
amending12308913amending
aneling82719503ane_ling
aneurin749833aneurin_
aneurins849073aneurins
angering102113803angering
appearing1436893appearing
arcing95819643a__rcing
arming94719803a__rming
armoring1149123armoring
aspersing1237603aspersing
aspiring1138873aspiring
asserting1038663asserting
assuring937773assuring
attiring939483attiring
auguring1036383auguring
availing1267283availing
averment13311603averment
averred11237593averr_ed
aversion1147313aversion
aversions1247053aversions
aversive1447443aversive
aviating12311013aviating
avoiding1336783avoiding
avowing1466603av_owing
avulsing1234433avulsing
awarding1356043awarding
aweing103911253awe__ing
barring104021593_barring
bearing103624773_bearing
beavering1538703beave_ring
berming123614833_berming
berrying14137373_berrying
birring103713063_birring
blearing113111943blearing
blurring11277233blurring
burring104016993_burring
capering132414963cape_ring
careering12311203careering
catering112019903cate_ring
caveating1539293caveating
cavorting1536063cavorting
cering94522533_ce_ring
charring142913163charring
cheering143612703cheering
chirring142610173chirring
churring14298653churring
clavering1538373clave_ring
clearing113014883clearing
clerking15257163clerking
coercing1349003coercing
covering142215723cove_ring
curring103616843_curring
davening13258873dave_ning
deferring1436143deferring
deterring1138623deterring
diverging15226693diverging
diverting142410333diverting
earing75235483__earing
earring83519013_earring
emerging1237893emerging
evening11310223eve_ning
everduring1543293everduring
exerting162211153exerting
favoring1596673fav_oring
favouring1644023favouring
fearing113520033_fearing
ferrying15146243_ferrying
fevering152510083fevering
fleering123811283fleering
furring114013143_furring
garring93116713_garring
gaveling133410163gave_ling
gavelling14286873gavelling
gearing92818843_gearing
gnarring10225973gnarring
governing1435533governing
havening15258553have_ning
hearing113324163_hearing
heiring113312903_heiring
herding122915123_herding
herrings12379533_herrings
herrying15147023_herrying
hovering151911143hove_ring
inferring1338613inferring
interring10315423interring
inversing1389623inversing
inverting131013223inverting
jarring153613193_jarring
jeering153513043_jeering
jerking19308923_jerking
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
kvelling16146513kvelling
lagering102212313lage_ring
layering122310353laye_ring
leering83417643_leering
levering122212503levering
livering122012383live_ring
marring103319553_marring
merging112711763_merging
metring103215293_metring
misaverring1743073misaverring
nearing83020333_nearing
nerving112910823_nerving
obverting1536303obverting
overarming1639233overarming
overawing16710293overawing
overbig13237543overbi_g
overcuring16108763overcuring
overdaring1539503overdaring
overdoing1439143overdoing
overdrink1746273overdrink
overdrying1846543overdrying
overhang15248863overhang
overhung15235623overhung
overkind1637953overkind
overlong1238123overlong
overlying1638003overlying
overmine13313663overmine
overprint14412253overprint
overran10311663overran_
overrank1548113overrank
overrating14814203overrating
overrich1648453overrich
override121512523override
overriding1548513overriding
overrife14169933overrife
overripe131410383overripe
overruling1467613overruling
overrun1038023overrun_
overruns1138173overruns
overswing1638453overswing
overtiring141210203overtiring
overturing1499413overturing
overurging1547113overurging
overusing1339043overusing
overwind1538533overwind
papering132213313pape_ring
parring103222063_parring
peering103520353_peering
perking143716463_perking
perming123416093_perming
piercing1346663piercing
preaverring1743243preaverring
purring104515823_purring
quavering2235953quave_ring
queering1838203queering
querying2135243querying
raveling123414373rave_ling
ravelling13269243ravelling
ravening122611293rave_ning
rearing83128783_rearing
referring1338033referring
reverbing15248593reverbing
revering122918073revering
reversing132611483reversing
reverting132315133reverting
sabering112113743sabe_ring
savoring1269483sav_oring
savouring1335193savouring
scarring112511513scarring
searing83330923_searing
serging93416673_serging
sering74731813_se_ring
serrying12167693_serrying
serving113014983_serving
severing122013853severing
shearing123915903shearing
sheering123715103sheering
shirring122910443shirring
skirring13297143skirring
slavering1338723slave_ring
slurring9288833slurring
smearing113511753smearing
smerking15258473smerking
sneering93414503sneering
sparring113112223sparring
spearing113216103spearing
speering113116323speering
speiring113711263speiring
spurring11339763spurring
starring92312953starring
steering93916793steering
sterling93615553sterling
stirring9299653stirring
swearing123711443swearing
swerving1546113swerving
tabering112211423tabe_ring
tapering112112503tape_ring
tarring83318303_tarring
tearing84021493_tearing
terming104016003_terming
terrine72517573_terrine
tiering8315253tie_ring
traversing1444803traversing
vaporing1437653vaporing
varying1429723_varying
vealing114217423_vealing
vegging13308873_vegging
veiling113615293_veiling
veining114713893_veining
veluring1237563_veluring
vending124015263_vending
venging123710943_venging
venting114218093_venting
verdin103113023_verdin_
verdins112812333_verdins
vermin113414523_vermin_
versine102515173_versine
vesting114618683_vesting
vetoing11309053_vetoing
vetting114216563_vetting
vexing17479173_ve_xing
viverrine1544673viverrine
wafering15208893wafe_ring
wagering13219523wage_ring
warring113717973_warring
watering122316313wate_ring
wearing113318863_wearing
wherrying1952993wherrying
whirring15286283whirring
yerking15368813_yerking
yirring11307763_yirring
zeroing1738343_zeroing

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.1561145455.1
2DLD Change Limit1461622698.32617554.9
3Display Results2692690.2201222.7
 (SQL Overall)1786912698.70220534.5
 
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.