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

172 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
silvering133791(None) 
silverings1443831silverings
slivering1338081slivering
desilvering1663302desilvering
filtering13199712filtering
livering122012372li_vering
pilfering1536382pilfering
resilvering1593742resilvering
severing122013852s_evering
shivering1637332shivering
silvern10347132silver_n_
simmering1467812simmering
simpering1449282simpering
sintering101014792sintering
sistering101213732sistering
slavering1338722slavering
soldering1169022soldering
tillering1037862tillering
wildering1456732wildering
altering91917113_altering
ashlering1344153ashl_ering
beavering1538703beavering
bickering1837653bickering
billeting1236633billeting
bittering122511983bittering
cindering13311213cindering
ciphering17217693ciphering
clavering1538373clavering
covering142215723_covering
culverin1345173culverin_
culverins1445373culverins
delivering1545173delivering
diapering1339023diapering
dickering1737453dickering
differing1746463differing
dithering1499843dithering
diverging15226693di_verging
diverting142410333di_verting
faltering132211113faltering
fevering152510083_fevering
fileting1239303fil_eting
filleting1335843filleting
fingering1439183fingering
fleering123811283_fleering
fullering1336653fullering
gibbering1534703gibbering
gingering1238863gingering
haltering132212003haltering
havering152211053_havering
hindering14310263hindering
hollering1337743hollering
hoovering1635753hoovering
hovering151911143_hovering
inhering12913703_inhering
inversing1389623_inversing
inverting131013223_inverting
jiggering1934293jiggering
jittering17218413jittering
kippering18205433kippering
leering83417643__leering
levering122212503_levering
limbering1488783limbering
lingering11310503lingering
lippering14217873lippering
littering102411973littering
livening12248153li_vening
mildening1345663mildening
mildewing1643723mildewing
mitering113015393mi_tering
moldering1367853moldering
nickering1636563nickering
niddering1255313niddering
nidering10510473ni_dering
niffering1645123niffering
overing111918053__overing
palavering1644483palavering
paltering122612893paltering
peltering122011673peltering
philtering1646253philtering
pillaring1237643pillaring
quavering2235953quavering
quivering2235873quivering
revering122918073_revering
riverine11310803ri_verine
riveting12139443ri_veting
sabering112113743s_abering
saggering12197793saggering
salvaging1465283salvaging
salving113913153salv__ing
salvoing1236423salv_oing
savoring1269483s_avoring
sering74731813s___ering
sewering122411093s_ewering
shaveling1646843shaveling
sheering123715103s_heering
sheltering1446493sheltering
shimmering1884623shimmering
shoveling1635553shoveling
showering1646403showering
sickening1635993sickening
sideling101012173si_deling
sieging92613203si__eging
sieving112311233si__eving
signeting1136223signeting
silencing1245053silencing
silking123715593sil__king
siloing83215493sil__oing
silting83320483sil__ting
silver93815813silver___
silvered12237563silver_ed
silverer11216733silver_er
silverers12215753silverers
silverfish1952173silverfish
silveriness1443853silveriness
silverly14284303silver_ly
silverpoint1651913silverpoint
silvers104714033silver__s
silverside1452773silverside
silvery13328093silver__y
sinewing1267593si_newing
singeing10209933singe_ing
siring75128313si___ring
skeltering1545003skeltering
skewering1744633skewering
skippering1943673skippering
skittering1535393skittering
sleeking133410963s_leeking
sleeping113812053s_leeping
sleeting93114163s_leeting
sleeving12359283s_leeving
slewing113311353s_l_ewing
slithering1496893slithering
slurring9288833s_lurring
smoldering1474103smoldering
sneering93414503s_neering
snickering1744853snickering
sniggering1343753sniggering
sniveling1336033sniveling
sobering111912783s_obering
soldiering1244243soldiering
solferino1243873solferino
solvating1336443solvating
solving112910853solv__ing
speering113116323s_peering
sphering142811943s_phering
spiering112713353s_piering
steering93916793s_teering
subvening1546033subvening
subverting1666293subverting
suckering1638103suckering
suffering1637293suffering
sulfuring1345783sulfuring
summering1458753summering
sundering11312313sundering
supering11317683s_upering
surveying1644963surveying
sweltering1445233sweltering
swithering17105213swithering
swiveling1634573swiveling
syphering18175733syphering
telfering1336253telfering
tiering8315243ti__ering
timbering14117713timbering
tinkering1437693tinkering
tittering102310303tittering
ulcering1139333_ulcering
wavering152410543_wavering
weltering13219493weltering
wintering13412353wintering
withering16108803withering
wolverine1554343wolverine
zippering23215193zippering

Search took 9 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.1531167915.0
2DLD Change Limit1486411728.69017104.8
3Display Results1721720.0762263.2
 (SQL Overall)1786911728.91920034.9
 
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.