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

254 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
sistering10121375(None) 
sintering101014801sintering
bittering122511992bittering
blistering13107062blistering
festering132413172festering
filtering13199722filtering
fostering132411262fostering
glistering12106422glistering
jittering17218422jittering
leistering1147982leistering
listening10128952listening
littering102411982littering
lustering102711202lustering
mastering122315302mastering
misterming1538602misterming
mitering113015402mi_tering
mustering122212332mustering
oystering1337562oystering
pestering122315662pestering
roistering1148582roistering
silvering1337922silvering
simmering1467822simmering
simpering1449292simpering
skittering1535392skittering
tittering102310312tittering
westering132112642westering
wintering13412362wintering
absterging1453353absterging
altering91917113_altering
answering1345803answering
bantering122414233bantering
bartering122313643bartering
battering122715143battering
bettering122212753bettering
bickering1837663bickering
bitewing1435293bi_tewing
blustering13106183blustering
bolstering1346883bolstering
buttering122312523buttering
cantering122417373cantering
catering112019903_catering
centering122915143centering
chittering16107183chittering
cindering13311223cindering
ciphering17217703ciphering
cistern93310703cister_n_
cisterna10376363cister_na
cisterns10369573cister_ns
cloistering1444823cloistering
clustering13116813clustering
coshering15510023coshering
cratering12312653cratering
diapering1339033diapering
dickering1737463dickering
differing1746473differing
discerning1447863discerning
dispersing1449303dispersing
disserting121310853disserting
disserving15117013disserving
distending1348333distending
distorting1239583distorting
disturbing1445653disturbing
dithering1499853dithering
entering91920053_entering
faltering132211113faltering
fastening13268603fastening
fettering132310513fettering
fingering1439193fingering
fissuring1344813fissuring
fisting113818123fist__ing
flittering1486503flittering
flustering14105933flustering
fosterling1445173fosterling
frittering14105623frittering
gartering112111573gartering
gesturing1136653gesturing
gettering112310033gettering
gibbering1534713gibbering
gingering1238873gingering
glistening1294283glistening
glittering1296003glittering
guttering112410443guttering
haltering132212003haltering
hastening13259483hastening
hindering14310273hindering
histing113720373hist__ing
holstering1447083holstering
hosteling1337893hosteling
inhering12913713_inhering
interning10315253_interning
interring10315423_interring
iteming1037753_i_teming
jiggering1934303jiggering
kashering1736253kashering
kippering18205443kippering
kittening1434593kittening
koshering1735363koshering
lettering102112073lettering
lightering15246113lightering
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
listeria839433listeri_a
listerias959233listerias
listing84020593list__ing
livering122012383li_vering
lobstering1345123lobstering
loitering1039683loitering
lustring9269723lust_ring
mattering122314053mattering
metering112915633_metering
ministering1445543ministering
misaltering1445123misaltering
misentering1446373misentering
misfiring1536973misfiring
mishearing1647883mishearing
missteering1444453missteering
mistaking1699693mistaking
mistending1447953mistending
mistiming1438913mistiming
misting103623383mist__ing
mistuning1237673mistuning
mistyping1744723mistyping
mitring103514143mi_t_ring
moistening1346233moistening
muttering122611323muttering
nattering102212213nattering
neutering1038963neutering
nickering1636573nickering
niddering1255323niddering
nidering10510483ni_dering
niffering1645133niffering
oysterings1443903oysterings
paltering122612893paltering
pastoring12310853pastoring
pasturing1238433pasturing
pattering122314423pattering
peltering122011673peltering
petering112516813_petering
philtering1646253philtering
picturing1436033picturing
pilfering1536393pilfering
pistoling1268493pistoling
plaistering1444603plaistering
plastering1339243plastering
portering122012303portering
posturing1238993posturing
pottering122612003pottering
puttering122611643puttering
registering1346393registering
restoring10314613restoring
restring91518783rest_ring
roystering1445413roystering
sabering112113743s_abering
saggering12197793saggering
sauntering1137223sauntering
sauteing937913saute_ing
scattering1398013scattering
sceptering1545793sceptering
scissoring1343303scissoring
scuttering1386633scuttering
sectoring1239583sectoring
sering74731813__s_ering
severing122013853s_evering
sewering122411093s_ewering
shattering1498283shattering
sheering123715103s_heering
sheltering1446493sheltering
shimmering1884623shimmering
shivering1637333shivering
showering1646403showering
shuttering1496563shuttering
sickening1635993sickening
sideling101012183si_deling
sieging92613203si__eging
sieving112311233si__eving
sifting113014593sift__ing
signeting1136223signeting
silting83320483silt__ing
silverings1443843silverings
sinewing1267593si_newing
singeing10209933singe_ing
siring75128313si___ring
sister64421583sister___
sistered92612803sister_ed
sisterly1146333sister_ly
sisters73721593sister__s
siting74126623si_t__ing
sitting83519633si_t_ting
skeltering1545003skeltering
skewering1744633skewering
skippering1943673skippering
slathering14108283slathering
slavering1338723slavering
slithering1496893slithering
slivering1338083slivering
smattering1397583smattering
smothering1646013smothering
sneering93414503s_neering
snickering1744863snickering
sniggering1343763sniggering
sobering111912783s_obering
softening1365493softening
soldering1169033soldering
spattering13107793spattering
speering113116323s_peering
sphering142811943s_phering
spiering112713353s_piering
splintering1444293splintering
sputtering13106463sputtering
staring84527053__staring
steering93916793s_teering
sterling93615553__sterling
stewing113412493__stewing
storing83921123__storing
string75327563__st_ring
stuttering1196353stuttering
suckering1638103suckering
suffering1637293suffering
summering1458753summering
sundering11312323sundering
supering11317683s_upering
suspiring1245703suspiring
suturing9310373s_uturing
sweltering1445233sweltering
swithering17105213swithering
syphering18175733syphering
tattering102212323tattering
teetering10239893teetering
tentering102313203tentering
tiering8315253ti__ering
tillering1037883tillering
timbering14117723timbering
tinkering1437703tinkering
tottering10229613tottering
twittering1444583twittering
unstring9312093unst_ring
upstaring1235963upstaring
ushering1258923_ushering
uttering91613083_uttering
vesturing1337203vesturing
viseing11299163vis_e_ing
visoring1238373vis_oring
waitering13310713waitering
watering122316313_watering
weltering13219493weltering
whispering1944343whispering
wildering1456743wildering
wisteria1147753wisteri_a
wisterias1248103wisterias
wisting113519743wist__ing
withering16108813withering
yattering132410443yattering
zippering23215203zippering

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.420425454.8
2DLD Change Limit1486412546.45323034.4
3Display Results2542540.1262015.9
 (SQL Overall)1786912546.99925530.9
 
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.