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

398 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
anearing941397(None) 
nearing83020331_nearing
aneling82719502ane_ling
aneurin749832aneurin_
aneurins849072aneurins
angering102113802angering
annealing1047452annealing
appearing1436892appearing
averring12239062averring
bearing103624772_bearing
blearing113111942blearing
clearing113014882clearing
earing75235482__earing
endearing1139322endearing
fearing113520032_fearing
gearing92818842_gearing
hangaring1438032hangaring
hearing113324162_hearing
kneading1436372kneading
rearing83128782_rearing
searing83330922_searing
shearing123915902shearing
smearing113511752smearing
snaring83920952sn_aring
sneaking133211092sneaking
sneaping11349492sneaping
sneering93414502sneering
spearing113216102spearing
swearing123711442swearing
tearing84021492_tearing
unbearing1239352unbearing
uncaring11312842uncaring
undaring10412752undaring
unerring9311272unerring
unfearing1338882unfearing
wearing113318862_wearing
aahing1019015763a__ahing
abasing10610673a_basing
abating10413973a_bating
abegging1334483abegging
abetting1158293abetting
abjuring1834883abjuring
ablating11311993ablating
abnegating1444463abnegating
abrading1239503abrading
acarine9316003a_carine
adeeming1254793adeeming
adhering1338883adhering
adjuring1735103adjuring
admiring1236133admiring
adoring9412523a_doring
aerating92821003aerating
ageing84213403age__ing
agenting1039383agenting
airing74927503a__iring
alarming1138583a_larming
alerting91312383alerting
aliasing9310073aliasing
allaying12339303allaying
alluring939073alluring
altering91917113altering
amazing1938813a_mazing
amending12308913amending
amercing1337193amercing
anchoring1548323anchoring
anear55420323anear___
aneared8512743anear_ed
anears63717183anear__s
aneurism1046643aneurism
angaria8311583angari_a
angarias9310553angarias
angaries9314393angaries
angeling102811733angeling
angling92816043an_gling
animating12312503animating
ankling122912063an_kling
annexing1635473annexing
annoying1246543annoying
anserine8313083anserine
answering1345803answering
antedating1277543antedating
anteing8312813an_teing
antiaging1149673antiaging
antiarin8413893antiarin_
antiarins9413883antiarins
antiking13412073antiking
anting75827023an__ting
anviling1239743anviling
anything1534993anything
appealing1446493appealing
appeasing1446343appeasing
arcading1239763arcading
armoring1149123armoring
arraying1238753arraying
ashlaring1344493ashlaring
aspiring1138873aspiring
assaying1236003assaying
assuring937773assuring
attiring939483attiring
auguring1036383auguring
avenging1345863avenging
averaging1446503averaging
averting122512733averting
aviating12311013aviating
awaking1547813a_waking
awarding1356043a_warding
aweing103911253awe__ing
bandaging1436063bandaging
banjaxing2642553banjaxing
bannering12208803bannering
bantering122414233bantering
baring95135853__baring
beading113221863_beading
beaming123618803_beaming
beaning103820683_beaning
bearding124011943_bearding
bearings113912253_bearings
beating104326873_beating
benaming1339693benaming
bewaring14279493bewaring
blaring104317113_blaring
bleating113514503bleating
breading123515463breading
breaking153914253breaking
breaming133612513breaming
canaling112016413can_aling
cankering162110793cankering
cantering122417373cantering
canvasing1546433canvasing
capering132414963cape_ring
careering12311203careering
caring95137993__caring
caseating12311743caseating
catering112019903cate_ring
caveating1539293caveating
ceasing104118263_ceasing
centring112112953centring
cering94522533_ce_ring
charing133721323_charing
cheating144014523cheating
cheering143612703cheering
cleaning113112383cleaning
clearings12286063clearings
clearwing1533673clearwing
cleating113518133cleating
cleaving141389683cleaving
creaking153414123creaking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
dandering122511063dandering
dangering12239303dangering
daring84928683__daring
deairing10311893_deairing
dealing94323233_dealing
deaning94020473_deaning
deaving123814753_deaving
dogearing1235763dogearing
dreading113712803dreading
dreaming124011063dreaming
earings84517713__earings
earning83418213__earning
earring83519013__earring
easing74926463__easing
eating75134403__eating
encaging1258733encaging
encasing11610823encasing
encoring11312173encoring
enduring10310013enduring
enfacing1467293enfacing
engaging1147373engaging
enlacing1148773enlacing
enlarging1135803enlarging
enraging1049573enraging
ensnaring1046383ensnaring
ensuring9310173ensuring
entering91920053entering
enuring8813883en_uring
erring73816483__erring
faring105231283__faring
feasing113916653_feasing
feazing205411443_feazing
flaring114116803_flaring
fleering123811283fleering
freaking163611453freaking
gandering122111293gandering
garnering11298083garne_ring
gearings10359503_gearings
glaring93714883_glaring
gleaming12277933gleaming
gleaning10269323gleaning
gnarling10217603gn_arling
gnarring10225973gnarring
gnawing12377903gn_awing
greasing102811393greasing
hankering17239383hankering
haring104233003__haring
havering152211053have_ring
heading122919113_heading
healing113922963_healing
heaping133015853_heaping
hearings123611853_hearings
hearsing1239383_hearsing
hearting12513123_hearting
heating114024323_heating
heaving144114763_heaving
heiring113312903_heiring
herring113615883_herring
ideating10311703ideating
inarming1138343in_arming
incaging1288673incaging
incasing11610603incasing
inearthing1443543inearthing
inferring1338613inferring
inhaling1239523inhaling
inhering12913713inhering
injuring1637473injuring
inlacing1158373inlacing
inlaying1247893inlaying
insnaring1046313insnaring
insuring9311153insuring
interring10315423interring
inuring81213013in_uring
invading1336263invading
inweaving1644773inweaving
jeering153513043_jeering
kneeing12226523kne_eing
kneeling13287783kneeling
knelling13319023knelling
lagering102212313lage_ring
laveering1336813laveering
layering122310353laye_ring
leading93419553_leading
leafing113313583_leafing
leaking123616973_leaking
leaning83721203_leaning
leaping103215993_leaping
learning978553_learning
leasing83920163_leasing
leaving114216853_leaving
leering83417643_leering
managing1239093man_aging
mandarin11411023mandarin_
mandarins12410393mandarins
mandating1339773mandating
manuring1139223man_uring
meaning103918703_meaning
menacing1339783menacing
metring103215293_metring
naething1236073naething
naming93917893_n_aming
narine63422553_n_arine
narking124015383_n_arking
necking143913893_necking
needing93214423_needing
negating102012833_negating
nerving112910823_nerving
nesting84320443_nesting
netting84018763_netting
neurine7311683_neurine
nonbearing1346453nonbearing
nonearning1145183nonearning
oaring74225303__oaring
overing111918053ove_ring
pancaking1836383pancaking
pandering133211963pandering
paneling111013623pane_ling
panelling1239073panelling
papering132213313pape_ring
paring94236493__paring
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
pearling11912013_pearling
peering103520353_peering
pleading123011443pleading
pleasing112611593pleasing
pleating112916053pleating
prearming14139223prearming
preparing14311643preparing
queering1838203queering
raring74332873__raring
reading93327213_reading
reaming103924013_reaming
reaping103621213_reaping
rearming111413613_rearming
reaving113820533_reaving
reearning1039053reearning
regearing112211413regearing
rehearing132211763rehearing
renaming11313693renaming
retearing102214253retearing
rewearing132310703rewearing
roaring82916003_roaring
sabering112113743sabe_ring
saggaring12236243saggaring
sandaling112010563sandaling
scaring103421973_scaring
sealing83528563_sealing
seaming103222113_seaming
seating84130683_seating
sering74731813_se_ring
sharing113723243_sharing
sheafing15329483sheafing
shealing123415463shealing
shearings13337563shearings
shearling1336923shearling
sheaving154110253sheaving
sheering123715103sheering
sleaving123310983sleaving
snaking123915303sn_aking
snarfing12358663sn_arfing
snarling92513183sn_arling
snawing113612483sn_awing
snedding11246953snedding
sneezing18267053sneezing
snelling93913563snelling
snoring83917203sn_oring
soaring83521893_soaring
sparing104823873_sparing
speaking153212493speaking
speaning113512243speaning
speering113116323speering
speiring113711263speiring
squaring18158633squaring
staring84527053_staring
steading103613593steading
stealing93416603stealing
steaming114013213steaming
stearin7312003stearin_
stearine8311903stearine
stearins8312143stearins
steering93916793steering
sugaring1039053sugaring
sweating123213023sweating
tabering112211423tabe_ring
tapering112112503tape_ring
taring73932283__taring
teaming103917593_teaming
teasing83918513_teasing
tenuring938863tenuring
tiering8315253tie_ring
treading103515333treading
treating92519613treating
tweaking1635883tweaking
unaging9510933un_aging
unarming1138623un_arming
unbaling11310683unbaling
unbarring1236063unbarring
uncaging1268713uncaging
uncaking1539463uncaking
uncasing11511003uncasing
unceasing1239653unceasing
unearthing1454373unearthing
unending10239943unending
unfading1347693unfading
ungazing1936033ungazing
unhairing1335953unhairing
unlacing1148643unlacing
unlading1058863unlading
unlaying1258363unlaying
unleading1138673unleading
unlearning1144713unlearning
unmaking1538133unmaking
unmeaning1237953unmeaning
unpaying1456943unpaying
unsaying1288153unsaying
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unsparing1237713unsparing
unstring9312093unstring
unswearing1444413unswearing
untiring9312003untiring
unvarying1644503unvarying
unwaning1238133unwaning
unweaving1636133unweaving
upbearing1435033upbearing
uprearing1238373uprearing
uptearing1236103uptearing
vealing114217423_vealing
veering113213683_veering
veneering1337663veneering
wafering15208893wafe_ring
wagering13219523wage_ring
wandering143310983wandering
waring105029443__waring
watering122316313wate_ring
wavering152410543wave_ring
wayfaring1942513wayfaring
weaning114117193_weaning
wearying1546703_wearying
weaving143211623_weaving
wreaking163010213wreaking
yealing112716383_yealing
yeaning113814633_yeaning
yearling1297883_yearling
yearning1296983_yearning

Search took 10 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.1731032896.0
2DLD Change Limit1461623988.68616827.3
3Display Results3983980.1732300.6
 (SQL Overall)1786913989.03219784.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.