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

122 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
sauntering113722(None) 
bantering122414232ba_ntering
cantering122417372ca_ntering
chuntering1647802chuntering
countering13314472countering
daundering1364462daundering
laundering1245182laundering
maundering1455352maundering
sauteing937912sau_te_ing
scunnering1344132scunnering
scuttering1386632scuttering
shuttering1496562shuttering
sintering101014802s_intering
sputtering13106462sputtering
stuttering1196352stuttering
sundering11312322s_undering
altering91917113_a_ltering
angering102113803_a_ngering
anteing8312813_a_nte_ing
bannering12208803ba_nnering
bartering122313643ba_rtering
battering122715143ba_ttering
blundering1444823blundering
blustering13106183blustering
bunkering16207103_bunkering
buttering122312523_buttering
cankering162110793ca_nkering
catering112019903ca__tering
centering122915143_centering
clustering13116813clustering
cluttering13106833cluttering
dandering122511063da_ndering
dangering12239303da_ngering
daunting103310403daunt__ing
entering91920053__entering
faltering132211113fa_ltering
flustering14105933flustering
fluttering14106293fluttering
foundering1545353foundering
gandering122111293ga_ndering
garnering11298083garn_ering
gartering112111573ga_rtering
gauffering1842453gauffering
gauntleting1351253gauntleting
guttering112410443_guttering
haltering132212003ha_ltering
hankering17239383ha_nkering
haunting123510053haunt__ing
hungering14187683_hungering
hunkering17227123_hunkering
jaunting16328633jaunt__ing
lustering102711203_lustering
mastering122315303ma_stering
mattering122314053ma_ttering
mustering122212333_mustering
muttering122611323_muttering
nattering102212213na_ttering
neutering1038963neu_tering
paltering122612893pa_ltering
pandering133211963pa_ndering
partnering1345553partnering
pattering122314423pa_ttering
paupering1437273pau_pering
plundering1444173plundering
puttering122611643_puttering
quartering2045843quartering
reentering1149983reentering
reuttering1137573reuttering
sabering112113743sa__bering
saggering12197793sa_ggering
sainting93215733saint__ing
sanderling1256653sa_nderling
santeria8311653sa_nteri_a
santerias9311843sa_nterias
saunaing937013saun__aing
saunter72913453saunter___
sauntered1036283saunter_ed
saunterer945033saunter_er
saunterers1044383saunterers
saunters82911753saunter__s
sauterne846253sau_ter_ne
scattering1398013scattering
sceptering1545793sceptering
scuppering1754023scuppering
shattering1498283shattering
sheltering1446493sheltering
shuddering1643513shuddering
shunting123610433shunt__ing
sistering101213753s_istering
skeltering1545003skeltering
skittering1535393skittering
slandering1237243slandering
slaughtering1752253slaughtering
slubbering15124923slubbering
slumbering15105323slumbering
smattering1397583smattering
sneering93414503s__neering
spattering13107793spattering
splintering1444293splintering
spluttering1463363spluttering
squandering2242953squandering
squattering2143803squattering
stunting92811503stunt__ing
suckering1638103s_uckering
suffering1637293s_uffering
summering1458753s_ummering
supering11317683s_u_pering
suturing9310373s_u_turing
sweltering1445233sweltering
tattering102212323ta_ttering
taunting93510933taunt__ing
tautening1035843tau_tening
tentering102313203_tentering
thundering1544573thundering
untiring9312003__untiring
uttering91613083__uttering
vaunting12338753vaunt__ing
waitering13310713wa_itering
wandering143310983wa_ndering
watering122316313wa__tering
wintering13412363_wintering
yattering132410443ya_ttering

Search took 7 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 Limit1406031226.04623255.5
3Display Results1221220.0631936.5
 (SQL Overall)1786911226.51527427.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.