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

420 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
altering9191711(None) 
faltering132211111faltering
haltering132212001haltering
paltering122612891paltering
adhering1338872adhering
alerting91312382al_erting
algerine9810282algerine
aliening91510892aliening
alleging1038472alleging
alluring939072alluring
alterant8614962alterant
alterity1149842alterity
angering102113802angering
anteing8312812ante_ing
attiring939482attiring
bantering122414232bantering
bartering122313642bartering
battering122715142battering
cantering122417372cantering
catering112019902catering
entering91920052entering
filtering13199712filtering
fleering123811282fleering
gartering112111572gartering
lagering102212312lagering
latening9711492latening
lathering13912252lathering
layering122310352layering
leering83417642_leering
mastering122315302mastering
mattering122314052mattering
metering112915632metering
mitering113015392mitering
nattering102212202nattering
pattering122314422pattering
peltering122011672peltering
petering112516812petering
realtering1139472realtering
tattering102212322tattering
ulcering1139332ulcering
uttering91613082uttering
waitering13310712waitering
watering122316312watering
weltering13219492weltering
yattering132410442yattering
abetting1158293abetting
abjuring1834873abjuring
absterging1453353absterging
acceding1446093acceding
acting95920983act__ing
adeeming1254793adeeming
adjuring1735093adjuring
admiring1236133admiring
adoring9412523a_doring
adulterine1143773adulterine
adverting1437223adverting
ageing84213403a_ge_ing
agreeing10295903agreeing
airing74927503a__iring
alarming1138583alarming
aldrin7311243al_drin_
aldrins8310203al_drins
alevin92511513al_evin_
alevins102110573al_evins
alexin132311483al_exin_
alexine142410543al_exine
alexins141910663al_exins
algerines1069083algerines
aliasing9310073aliasing
alibiing1135323alibiing
aligning10158533aligning
alining81917043al_ining
allaying12339303allaying
allergin9136303allergin_
allergins10146383allergins
allowing12369093allowing
alloying12339143alloying
alluding1036953alluding
allying113011663al_lying
alter54828503alter___
alterants979093alterants
altercating1455603altercating
altered83215733alter_ed
alterer72713993alter_er
alterers82512493alterers
alternant977133alternant
alternating1245713alternating
alters64924223alter__s
amberina1247383amberina
amercing1337193a_mercing
anearing9413973anearing
aneling82719503a_neling
angeling102811733angeling
annexing1635473annexing
anserine8313083anserine
answering1345803answering
anterior8611053anterior
antheming1587293antheming
antiking13412063antiking
anting75827023ant__ing
appearing1436893appearing
apteria9312913apteri_a
apterium1249133apterium
armoring1149123armoring
arterial8313623arterial
arteries8321463arteries
ashlering1344153ashlering
aspersing1237603aspersing
aspiring1138873aspiring
asserting1038663asserting
assuring937773assuring
asteria7316173asteri_a
asterias8317003asterias
asterisk1248673asterisk
asterism10413253asterism
astern64815813aster_n_
astringe938223ast_ringe
atheling1249203atheling
atoning83514873a_toning
attending11136373attending
attesting1036383attesting
attorning1045503attorning
attuning935903attuning
auguring1036383auguring
authoring1348583authoring
autoing8314043aut_oing
averring12239063averring
averting122512733a_verting
aweing103911253a_we_ing
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436953badgering
ballerina1146483ballerina
bannering12208803bannering
barbering14229683barbering
battening12268853battening
bettering122212753bettering
bitewing1435293bitewing
bittering122511983bittering
blaring104317113bl_aring
blathering16107583blathering
blattering13108713blattering
blearing113111943blearing
bleeding12359053bleeding
bleeping13377933bleeping
blethering16115933blethering
blistering13107063blistering
blithering16116123blithering
blueing103710203blue_ing
blurring11277233blurring
blustering13106183blustering
bolstering1346873bolstering
bothering152210203bothering
bowering142911713bowering
buttering122312523buttering
calipering1545003calipering
cambering16109863cambering
cankering162110793cankering
capering132414963capering
capturing1436613capturing
careering12311203careering
centering122915143centering
cering94522533__cering
chaptering18107953chaptering
chartering16109243chartering
chattering16108633chattering
cheering143612703cheering
clattering13109233clattering
clavering1538373clavering
clearing113014883clearing
cleeking15267813cleeking
cleping123310423cl_eping
clerking15257163cl_erking
clewing13359583cl_ewing
cloturing1245473cloturing
clouring112811273clouring
clueing104110093clue_ing
clustering13116813clustering
cluttering13106833cluttering
cohering142413833cohering
covering142215723covering
cowering142514033cowering
cratering12312653cratering
culturing1236553culturing
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dandering122511053dandering
dangering12239303dangering
deterging1237853deterging
deterring1138623deterring
dithering1499843dithering
dowering132510613dowering
elaterin849903elaterin_
elaterins9410033elaterins
factoring1537523factoring
falteringly1843133falteringly
fastening13268603fastening
fathering161010093fathering
fattening13287833fattening
festering132413173festering
fettering132310513fettering
fevering152510083fevering
flaring114116803fl_aring
flattering1498743flattering
fleecing14347573fleecing
fleeing113511293fl_eeing
fleeting122910323fleeting
flexing18358993fl_exing
fleying14329873fl_eying
flittering1486503flittering
flooring12259883flooring
flouring123010143flouring
flowering1636053flowering
flustering14105933flustering
fluttering14106293fluttering
fostering132411253fostering
fullering1336653fullering
gallerying1543033gallerying
galleting1137623galleting
gandering122111283gandering
garnering11298083garnering
gathering1499463gathering
gettering112310033gettering
glairing1047283glairing
glaring93714883gl_aring
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gl_eying
glistering12106423glistering
glittering1296003glittering
glowering1435653glowering
glueing9338713glue_ing
guttering112410443guttering
halting114419073halt__ing
hammering1737623hammering
hampering1738853hampering
hankering17239383hankering
hastening13259483hastening
havering152211053havering
hollering1337743hollering
holstering1447073holstering
homering141512073homering
hovering151911143hovering
inhering12913703inhering
interning10315253interning
interring10315423interring
iteming1037753_iteming
jabbering2134443jabbering
jeering153513043_jeering
jittering17218413jittering
kashering1736253kashering
laagering1136833laagering
labeling11311643labeling
laboring112110143laboring
lacewing1435843lacewing
lackering1639373lackering
laddering1237583laddering
ladening1078823ladening
lairing83715343_lairing
lappering14258843lappering
latching143712023latching
lateraling11148803lateraling
laterite8716333laterite
laterize17613293laterize
laterizing2049083laterizing
lathing114315693lat_hing
latrine7715123lat_rine
laveering1336813laveering
lawyering1655213lawyering
layerings13235673layerings
lettering102112073lettering
letting83218533_letting
levering122212503levering
littering102411973littering
livering122012373livering
loitering1039683loitering
louring83916503_louring
lowering122210913lowering
luring73820753_l_uring
lustering102711203lustering
malting103219083malt__ing
mammering1337333mammering
martyring1535773martyring
maturing1139953maturing
metring103215283met_ring
misaltering1445123misaltering
mitring103514143mit_ring
moldering1367853moldering
mothering152110183mothering
motoring11410953motoring
mustering122212333mustering
muttering122611323muttering
neutering1038953neutering
nidering10510473nidering
ochering14219393ochering
offering1536393offering
ordering1039343ordering
outring84021013out_ring
overing111918053_overing
oystering1337553oystering
palavering1644483palavering
palleting1238733palleting
pampering1638383pampering
pandering133211953pandering
papering132213313papering
partnering1345553partnering
pastoring12310843pastoring
pasturing1238433pasturing
patterning1346073patterning
paupering1437273paupering
peering103520353_peering
pestering122315663pestering
philtering1646253philtering
pilfering1536383pilfering
plastering1339243plastering
portering122012303portering
pothering151911283pothering
pottering122612003pottering
powering142210803powering
prealtering1446173prealtering
pterin81014153_pterin_
pterins9812993_pterins
puttering122611643puttering
quartering2045843quartering
queering1838203queering
rapturing1245353rapturing
rattening10288763rattening
retearing102214253retearing
retiring92717413retiring
revering122918073revering
rogering10310273rogering
sabering112113743sabering
saggering12197793saggering
saltern74010653salter_n_
salterns8388893salter_ns
salting84120793salt__ing
sauntering1137223sauntering
sauteing937913saute_ing
scattering1398013scattering
sering74731813__sering
severing122013853severing
sewering122411093sewering
shattering1498283shattering
sheering123715103sheering
sheltering1446493sheltering
silvering1337913silvering
sintering101014793sintering
sistering101213733sistering
skeltering1545003skeltering
slathering14108283slathering
slavering1338723slavering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sl_ewing
slithering1496893slithering
slivering1338083slivering
slurring9288833slurring
smattering1397583smattering
sneering93414503sneering
sobering111912783sobering
soldering1169023soldering
spattering13107793spattering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
staring84527053_staring
steering93916793steering
sterling93615553_sterling
stewing113412493_stewing
storing83921123_storing
string75327563_st_ring
supering11317683supering
suturing9310373suturing
sweltering1445233sweltering
tabering112211423tabering
tampering1438453tampering
tapering112112503tapering
taring73932283__taring
tautening1035843tautening
tearing84021493__tearing
teeing73916973__teeing
teetering10239893teetering
telfering1336253telfering
tentering102313203tentering
terming104015993__terming
tethering1339133tethering
tewing103914823__tewing
tiering8315243_tiering
tillering1037863tillering
tiring74023093__tiring
tittering102310303tittering
tottering10229613tottering
towering122610873towering
tutoring938433tutoring
tyring104613023__tyring
ulterior845443ulterior
umbering1399433umbering
unfaltering1543263unfaltering
untiring9312003untiring
uptearing1236103uptearing
ushering1258923ushering
uterine7315193_uterine
valeting1238843val_eting
veering113213683_veering
wafering15208893wafering
wagering13219523wagering
waltzing2134263walt_zing
wandering143310973wandering
waterings13229243waterings
wavering152410543wavering
westering132112643westering
wildering1456733wildering
wintering13412353wintering
withering16108803withering
wuthering1697803wuthering
yabbering1734023yabbering
yammering1735193yammering

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.1561145455.1
2DLD Change Limit1461624208.75016704.2
3Display Results4204200.1902210.5
 (SQL Overall)1786914209.09619645.0
 
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.