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

113 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
sputtering1310646(None) 
puttering122611641_puttering
scuttering1386631scuttering
shuttering1496561shuttering
spattering13107791spattering
spluttering1463361spluttering
stuttering1196351stuttering
buttering122312522_buttering
cluttering13106832cluttering
fluttering14106292fluttering
guttering112410442_guttering
muttering122611322_muttering
pattering122314422_pattering
pottering122612002_pottering
reuttering1137572reuttering
sauntering1137222sauntering
scattering1398012scattering
shattering1498282shattering
skittering1535392skittering
smattering1397582smattering
splattering1454542splattering
squattering2143802squattering
uttering91613082__uttering
battering122715143_battering
bespattering1752343bespattering
bettering122212753_bettering
bittering122511993_bittering
blattering13108713blattering
blustering13106183blustering
chattering16108643chattering
chittering16107183chittering
chuntering1647803chuntering
clattering13109233clattering
clustering13116813clustering
countering13314473countering
fettering132310513_fettering
flattering1498743flattering
flittering1486503flittering
flustering14105933flustering
frittering14105623frittering
gettering112310033_gettering
glittering1296003glittering
gutterings12224913_gutterings
jittering17218423_jittering
lettering102112073_lettering
littering102411983_littering
lustering102711203_lustering
mattering122314053_mattering
mustering122212333_mustering
nattering102212213_nattering
neutering1038963neu_tering
paltering122612893_paltering
patterning1346073_patterning
peltering122011673_peltering
pestering122315663_pestering
petering112516813_p_etering
portering122012303_portering
pothering151911283_pothering
puckering1835883_puckering
putting103218573_putt__ing
puttying1434953_putt_ying
sauteing937913sau_te_ing
scatterings14103973scatterings
sceptering1545793sceptering
scouthering1743483scouthering
scunnering1344133scunnering
scuppering1754023scuppering
scuttling1234243scutt_ling
sheltering1446493sheltering
shuddering1643513shuddering
shutterbug1671663shutterbug
shutting12309693shutt__ing
shuttling1334293shutt_ling
sintering101014803s_intering
sistering101213753s_istering
skeltering1545003skeltering
slathering14108283slathering
slithering1496893slithering
slubbering15124923slubbering
slumbering15105323slumbering
smatterings14103843smatterings
smothering1646013smothering
smutting11278063smutt__ing
spatting113111763spatt__ing
speering113116323sp__eering
sphering142811943sp__hering
spiering112713353sp__iering
spitting113012323spitt__ing
splintering1444293splintering
spotting112812093spott__ing
spurring11339763spu__rring
spurting113111633spurt__ing
sputter94014053sputter___
sputtered12166323sputter_ed
sputterer11165263sputter_er
sputterers12174583sputterers
sputters104012873sputter__s
sputtery13366473sputter__y
steering93916793s__teering
suckering1638103s_uckering
suffering1637293s_uffering
summering1458753s_ummering
sundering11312323s_undering
supering11317683s_u_pering
suturing9310373s_u_turing
sweltering1445233sweltering
swithering17105213swithering
tattering102212323_tattering
tittering102310313_tittering
tottering10229613_tottering
twittering1444583twittering
wuthering1697803_wuthering
yattering132410443_yattering

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031136.73620873.4
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.18824859.6
 
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.