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

198 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
peltering12201167(None) 
paltering122612901paltering
pestering122315661pestering
petering112516811pe_tering
weltering13219491weltering
altering91917122_altering
bettering122212762bettering
centering122915142centering
entering91920052_entering
faltering132211122faltering
festering132413172festering
fettering132310512fettering
filtering13199722filtering
gettering112310032gettering
haltering132212012haltering
lettering102112072lettering
metering112915632me_tering
neutering1038962neutering
pattering122314432pattering
peering103520352pe__ering
pelerine10313012pel_erine
pelleting1237952pelleting
pelting102917272pelt__ing
peppering1337082peppering
philtering1646252philtering
pilfering1536392pilfering
portering122012302portering
pottering122612002pottering
prealtering1446172prealtering
puttering122611642puttering
realtering1139472realtering
sheltering1446492sheltering
skeltering1545002skeltering
sweltering1445232sweltering
teetering10239892teetering
telfering1336252telfering
tentering102313212tentering
westering132112642westering
bantering122414243bantering
bartering122313653bartering
battering122715153battering
beavering1538703beavering
believing1535283believing
belting104119133belt__ing
bittering122512003bittering
blethering16115933blethering
bolstering1346883bolstering
buttering122312533buttering
cantering122417383cantering
catering112019913_catering
cellaring1238533cellaring
centerings13247673centerings
centring112112953cent_ring
cratering12312653cratering
culturing1236553culturing
deleing93313953del_e_ing
deleting103314423del_eting
delivering1545173delivering
delustering1344073delustering
deterging1237853de_terging
deterring1138623de_terring
dewatering1545773dewatering
elaterin849903_elaterin_
elaterins9410033_elaterins
feathering17108793feathering
featuring1337323featuring
felting113515213felt__ing
fevering152510083fe_vering
fleering123811283_fleering
fostering132411263fostering
fullering1336653fullering
gartering112111593gartering
gendering12249753gendering
gesturing1136653gesturing
guttering112410443guttering
hectoring1538303hectoring
helmeting1545503helmeting
hollering1337743hollering
holstering1447083holstering
jeering153513043je__ering
jittering17218423jittering
leathering1488683leathering
lechering1538443lechering
lecturing1237303lecturing
leering83417643__leering
leistering1147983leistering
letterings11226003letterings
levering122212503le_vering
littering102411983littering
loitering1039683loitering
lustering102711203lustering
mastering122315313mastering
mattering122314063mattering
melting103317753melt__ing
mentoring1239543mentoring
metring103215293me_t_ring
mitering113015403_mitering
moldering1367863moldering
mustering122212333mustering
muttering122611323muttering
nattering102212223nattering
neatening1038353neatening
oystering1337563oystering
palavering1644483palavering
palleting1238743palleting
pampering1638383pampering
pandering133211963pandering
papering132213313p_apering
partnering1345553partnering
pastoring12310853pastoring
pasturing1238433pasturing
patterning1346073patterning
paupering1437273paupering
pectizing2348013pectizing
peeing94618083pe__e_ing
peeking144414953pe__eking
peeling102919873pe__eling
peening103318303pe__ening
peeping123615213pe__eping
peeving135112243pe__eving
pelerines11311843pel_erines
pelter83321623pelter___
peltered112510453pelter_ed
pelters93720313pelter__s
peltries10313023pelt_ries
peptizing2347113peptizing
perduring1336013perduring
perjuring1944923perjuring
perturbing1543563perturbing
perverting1646623perverting
pestling111010253pest_ling
petting103720953pe_t_ting
pettling1168213pe_ttling
philtring1544173philt_ring
picturing1436033picturing
pillaring1237653pillaring
plastering1339243plastering
pollening1236923pollening
pondering132411333pondering
posturing1238993posturing
pothering151911283pothering
powdering16246503powdering
powering142210803p_owering
premiering1547243premiering
prestoring13310303prestoring
pterin81014153p__terin_
pterins9812993p__terins
puckering1835883puckering
reentering1149993reentering
refiltering1544823refiltering
relettering1255513relettering
reletting102713943reletting
relieving1336693relieving
rendering112213183rendering
restoring10314613restoring
restring91518783rest_ring
retearing102214253re_tearing
retiring92717413re_tiring
reuttering1137573reuttering
revering122918073re_vering
sceptering1545793sceptering
sectoring1239583sectoring
severing122013853se_vering
sewering122411093se_wering
silvering1337923silvering
sintering101014803sintering
sistering101213753sistering
soldering1169033soldering
spattering13107793spattering
speering113116323spe__ering
sputtering13106463sputtering
tattering102212333tattering
teddering12256303teddering
telexing1646613tel_exing
telneting1035593telneting
telphering1644203telphering
tempering1438733tempering
tendering112210813tendering
tethering1339133tethering
texturing1735223texturing
tillering1037883tillering
tittering102310313tittering
tottering10229613tottering
ulcering1139333_ulcering
uttering91613083_uttering
vectoring1537413vectoring
veering113213683ve__ering
veluring1237563vel_uring
veneering1337663veneering
venturing1337553venturing
vesturing1337203vesturing
waitering13310723waitering
watering122316323_watering
weathering1798353weathering
welting113615313welt__ing
wildering1456743wildering
wintering13412363wintering
yattering132410453yattering

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411986.75022020.9
3Display Results1981980.0932129.0
 (SQL Overall)1786911987.27924548.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.