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
altering9191712(None) 
faltering132211121faltering
haltering132212011haltering
paltering122612901paltering
adhering1338882adhering
alerting91312382al_erting
algerine9810282algerine
aliening91510892aliening
alleging1038472alleging
alluring939072alluring
alterant8614962alterant
alterity1149852alterity
angering102113802angering
anteing8312812ante_ing
attiring939482attiring
bantering122414242bantering
bartering122313652bartering
battering122715152battering
cantering122417382cantering
catering112019912catering
entering91920052entering
filtering13199722filtering
fleering123811282fleering
gartering112111592gartering
lagering102212312lagering
latening9711492latening
lathering13912252lathering
layering122310352layering
leering83417642_leering
mastering122315312mastering
mattering122314062mattering
metering112915632metering
mitering113015402mitering
nattering102212222nattering
pattering122314432pattering
peltering122011672peltering
petering112516812petering
realtering1139472realtering
tattering102212332tattering
ulcering1139332ulcering
uttering91613082uttering
waitering13310722waitering
watering122316322watering
weltering13219492weltering
yattering132410452yattering
abetting1158293abetting
abjuring1834883abjuring
absterging1453353absterging
acceding1446093acceding
acting95920983act__ing
adeeming1254793adeeming
adjuring1735103adjuring
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
allaying12339313allaying
allergin9136303allergin_
allergins10146383allergins
allowing12369093allowing
alloying12339143alloying
alluding1036953alluding
allying113011663al_lying
alter54828503alter___
alterants979103alterants
altercating1455603altercating
altered83215753alter_ed
alterer72714013alter_er
alterers82512503alterers
alternant977133alternant
alternating1245713alternating
alters64924223alter__s
amberina1247403amberina
amercing1337193a_mercing
anearing9413973anearing
aneling82719503a_neling
angeling102811733angeling
annexing1635473annexing
anserine8313093anserine
answering1345803answering
anterior8611063anterior
antheming1587293antheming
antiking13412073antiking
anting75827023ant__ing
appearing1436893appearing
apteria9312923apteri_a
apterium1249143apterium
armoring1149123armoring
arterial8313653arterial
arteries8321513arteries
ashlering1344153ashlering
aspersing1237603aspersing
aspiring1138873aspiring
asserting1038663asserting
assuring937773assuring
asteria7316203asteri_a
asterias8317033asterias
asterisk1248693asterisk
asterism10413273asterism
astern64815813aster_n_
astringe938223ast_ringe
atheling1249203atheling
atoning83514873a_toning
attending11136373attending
attesting1036383attesting
attorning1045503attorning
attuning935903attuning
auguring1036383auguring
authoring1348583authoring
autoing8314043aut_oing
averring12239063averring
averting122512733a_verting
aweing103911253a_we_ing
bacterin12410283bacterin_
bacterins13410653bacterins
badgering1436973badgering
ballerina1146493ballerina
bannering12208813bannering
barbering14229693barbering
battening12268863battening
bettering122212763bettering
bitewing1435293bitewing
bittering122512003bittering
blaring104317113bl_aring
blathering16107583blathering
blattering13108723blattering
blearing113111943blearing
bleeding12359053bleeding
bleeping13377933bleeping
blethering16115933blethering
blistering13107063blistering
blithering16116123blithering
blueing103710203blue_ing
blurring11277233blurring
blustering13106183blustering
bolstering1346883bolstering
bothering152210203bothering
bowering142911713bowering
buttering122312533buttering
calipering1545003calipering
cambering16109873cambering
cankering162110793cankering
capering132414963capering
capturing1436623capturing
careering12311203careering
centering122915143centering
cering94522533__cering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
cheering143612703cheering
clattering13109233clattering
clavering1538373clavering
clearing113014883clearing
cleeking15267813cleeking
cleping123310423cl_eping
clerking15257163cl_erking
clewing13359583cl_ewing
cloturing1245473cloturing
clouring112811273clouring
clueing104110093clue_ing
clustering13116813clustering
cluttering13106833cluttering
cohering142413833cohering
covering142215723covering
cowering142514033cowering
cratering12312653cratering
culturing1236553culturing
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
deterging1237853deterging
deterring1138623deterring
dithering1499853dithering
dowering132510613dowering
elaterin849903elaterin_
elaterins9410033elaterins
factoring1537543factoring
falteringly1843163falteringly
fastening13268603fastening
fathering161010093fathering
fattening13287833fattening
festering132413173festering
fettering132310513fettering
fevering152510083fevering
flaring114116803fl_aring
flattering1498743flattering
fleecing14347573fleecing
fleeing113511293fl_eeing
fleeting122910323fleeting
flexing18358993fl_exing
fleying14329873fl_eying
flittering1486503flittering
flooring12259883flooring
flouring123010143flouring
flowering1636053flowering
flustering14105933flustering
fluttering14106293fluttering
fostering132411263fostering
fullering1336653fullering
gallerying1543033gallerying
galleting1137633galleting
gandering122111293gandering
garnering11298093garnering
gathering1499463gathering
gettering112310033gettering
glairing1047283glairing
glaring93714883gl_aring
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gl_eying
glistering12106423glistering
glittering1296003glittering
glowering1435653glowering
glueing9338713glue_ing
guttering112410443guttering
halting114419073halt__ing
hammering1737633hammering
hampering1738863hampering
hankering17239383hankering
hastening13259483hastening
havering152211053havering
hollering1337743hollering
holstering1447083holstering
homering141512073homering
hovering151911143hovering
inhering12913713inhering
interning10315253interning
interring10315423interring
iteming1037753_iteming
jabbering2134443jabbering
jeering153513043_jeering
jittering17218423jittering
kashering1736253kashering
laagering1136833laagering
labeling11311653labeling
laboring112110143laboring
lacewing1435843lacewing
lackering1639383lackering
laddering1237593laddering
ladening1078823ladening
lairing83715343_lairing
lappering14258843lappering
latching143712023latching
lateraling11148803lateraling
laterite8716353laterite
laterize17613313laterize
laterizing2049103laterizing
lathing114315693lat_hing
latrine7715133lat_rine
laveering1336813laveering
lawyering1655213lawyering
layerings13235683layerings
lettering102112073lettering
letting83218533_letting
levering122212503levering
littering102411983littering
livering122012383livering
loitering1039683loitering
louring83916503_louring
lowering122210913lowering
luring73820753_l_uring
lustering102711203lustering
malting103219083malt__ing
mammering1337333mammering
martyring1535783martyring
maturing1139963maturing
metring103215293met_ring
misaltering1445123misaltering
mitring103514143mit_ring
moldering1367863moldering
mothering152110183mothering
motoring11410953motoring
mustering122212333mustering
muttering122611323muttering
neutering1038963neutering
nidering10510483nidering
ochering14219393ochering
offering1536393offering
ordering1039353ordering
outring84021023out_ring
overing111918053_overing
oystering1337563oystering
palavering1644483palavering
palleting1238743palleting
pampering1638383pampering
pandering133211963pandering
papering132213313papering
partnering1345553partnering
pastoring12310853pastoring
pasturing1238433pasturing
patterning1346073patterning
paupering1437273paupering
peering103520353_peering
pestering122315663pestering
philtering1646253philtering
pilfering1536393pilfering
plastering1339243plastering
portering122012303portering
pothering151911283pothering
pottering122612003pottering
powering142210803powering
prealtering1446173prealtering
pterin81014153_pterin_
pterins9812993_pterins
puttering122611643puttering
quartering2045853quartering
queering1838203queering
rapturing1245363rapturing
rattening10288763rattening
retearing102214253retearing
retiring92717413retiring
revering122918073revering
rogering10310273rogering
sabering112113743sabering
saggering12197793saggering
saltern74010653salter_n_
salterns8388903salter_ns
salting84120793salt__ing
sauntering1137223sauntering
sauteing937913saute_ing
scattering1398013scattering
sering74731813__sering
severing122013853severing
sewering122411093sewering
shattering1498283shattering
sheering123715103sheering
sheltering1446493sheltering
silvering1337923silvering
sintering101014803sintering
sistering101213753sistering
skeltering1545003skeltering
slathering14108283slathering
slavering1338723slavering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sl_ewing
slithering1496893slithering
slivering1338083slivering
slurring9288833slurring
smattering1397583smattering
sneering93414503sneering
sobering111912783sobering
soldering1169033soldering
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
tentering102313213tentering
terming104016003__terming
tethering1339133tethering
tewing103914823__tewing
tiering8315253_tiering
tillering1037883tillering
tiring74023093__tiring
tittering102310313tittering
tottering10229613tottering
towering122610873towering
tutoring938433tutoring
tyring104613023__tyring
ulterior845453ulterior
umbering1399433umbering
unfaltering1543263unfaltering
untiring9312003untiring
uptearing1236103uptearing
ushering1258923ushering
uterine7315193_uterine
valeting1238853val_eting
veering113213683_veering
wafering15208893wafering
wagering13219523wagering
waltzing2134263walt_zing
wandering143310983wandering
waterings13229263waterings
wavering152410543wavering
westering132112643westering
wildering1456743wildering
wintering13412363wintering
withering16108813withering
wuthering1697803wuthering
yabbering1734023yabbering
yammering1735193yammering

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.420425454.8
2DLD Change Limit1461624207.26620115.9
3Display Results4204200.1732427.7
 (SQL Overall)1786914207.85922737.1
 
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.