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

133 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
snippets1222562(None) 
sippets113310181s_ippets
skippets16284561skippets
snippers12299721snippers
snippet113310431snippet_
snippety15263491snippety
nippers113012622_nippers
shippens15316802shippens
shippers153012312shippers
sippers113117752s_ippers
sippet103519392s_ippet_
skippers16318202skippers
skippet15288462skippet_
slippers123711232slippers
snappers123510172snappers
sniglets9276812sniglets
snipers93311772sni_pers
snipes83917392sni_pe_s
snipped123510042snippe_d
snipper113911332snippe_r
snippiest1345722snippiest
tippets11339372_tippets
trippets12357422trippets
whippets18255252whippets
chippers173510883chippers
clippers14368843clippers
dipnets10109033_dipnets
dippers123615183_dippers
drippers13327943drippers
flippers15338003flippers
flippest1535173flippest
gippers123212083_gippers
grippers13358133grippers
grippes124810373grippe_s
hippest14219753_hippest
kippers153211433_kippers
knappers16315643knappers
lappets11329123_lappets
limpets11329783_limpets
lippens11328533_lippens
lippers113416443_lippers
moppets13307163_moppets
nappers114214863_nappers
nappes104515623_nappe_s
nidgets9358143_nidgets
nipped113615853_nippe_d
nipper103715713_nippe_r
nippiest12279973_nippiest
nipples11319663_nipples
pipets105714773_pi_pets
poppets10338853_poppets
puppets10317013_puppets
quippers2184813quippers
rippers114115033_rippers
ripplets12316733_ripplets
sappers113518903s_appers
scuppers1446543scuppers
septets998953s_eptets
shipless13277693shipless
shipments16254703shipments
shipped153312103shippe_d
shippen14298863shippe_n
shipper143514043shippe_r
shippons15255663shippons
shoppers153010763shoppers
shoppes143411393shoppe_s
signets83311503s_ignets
simpers113014123s_impers
singlets93611473singlets
sipes76036953s_i_pe_s
sipped113720633s_ippe_d
sipper103920993s_ippe_r
skillets12226823skillets
skipped16358413skippe_d
skipper15339573skippe_r
skirrets12244013skirrets
slappers123710943slappers
slipes84921413sli_pe_s
slipless10246993slipless
slipouts1044893slipouts
slipped124711743slippe_d
slipper113712983slippe_r
slippery15275863slippery
slippiest1346463slippiest
snapless10287463snapless
snapped124611203snappe_d
snapper113512073snappe_r
snappiest1346493snappiest
snickers143010963snickers
snidest8310913sni_dest
sniffers14257123sniffers
snifters11318613snifters
sniggers10317093sniggers
sniglet83612413sniglet_
snipe75320573sni_pe__
sniped94913483sni_pe_d
sniper84413643sni_pe_r
snippetier1451623snippetier
snippetiest1551743snippetiest
snippier1255793snippier
snippily1543573snippily
snipping13308853snipping
snippy1374843snipp__y
snips75818013sni_p__s
snits54124833sni___ts
snivels10336903sni_vels
snoopers10319843snoopers
spinets94714813spi_nets
steppers12289283steppers
steppes113110693steppe_s
stipels9418953sti_pels
stipes84524053sti_pe_s
stipites1039653stipites
stipplers1334453stipplers
stipples1247023stipples
stirpes95011293stirpe_s
stoppers123910593stoppers
strippers1355773strippers
suppers113314703s_uppers
swappers15358083swappers
swipes114114333swi_pe_s
swiples12339643swiple_s
swipples1534843swipples
swivets13436963swi_vets
tappets113610013_tappets
tippers113414353_tippers
tippet103917873_tippet_
triplets103510263triplets
trippers123210163trippers
trippet113714113trippet_
whippers18329043whippers
whippet17328843whippet_
zippers203310383_zippers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621337.17020385.2
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.38924183.4
 
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.