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 “supped” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
supped11441570(None) 
cupped134413981cupped
dupped124411641dupped
pupped105013271pupped
sapped114422011sapped
sipped113720631sipped
sopped114819901sopped
supper104115431supper
suppled1248461suppled
tupped114013231tupped
upped103715161_upped
bopped134413402bopped
bumped134414002bumped
burped116215502burped
capped134721852capped
copped135221252copped
cupper124313862cupper
cusped114312042cusped
dapped124516762dapped
dipped123517492dipped
dumped123814492dumped
duped95118322du_ped
fopped144012672fopped
gapped124217122gapped
gipped124815902gipped
gulped104610372gulped
gypped15377112gypped
happed144820102happed
hipped144317692hipped
hopped144318112hopped
humped144015242humped
jumped183511552jumped
kepped15309542kepped
kipped153114572kipped
lapped114320032lapped
lipped114419542lipped
lopped114218622lopped
lumped114216962lumped
mapped134015882mapped
mopped134114322mopped
mumped133813162mumped
napped114218162napped
nipped113615852nipped
pepped103113402pepped
pipped104516542pipped
popped104117812popped
pulped114612532pulped
pumped133915562pumped
puppet93514592puppet
quipped2175162quipped
rapped114122682rapped
repped114616722repped
ripped114419012ripped
sapper103822352sapper
scaped115519552scaped
scoped115116652scoped
sculped12398252sculped
scupper1367422scupper
seeped94317522seeped
shaped125020102shaped
shipped153312102shipped
shopped153512212shopped
siped84927682s_iped
sipper103920992sipper
sippet103519392sippet
skipped16358412skipped
slapped123511842slapped
sliped95417062sliped
slipped124711742slipped
sloped94216852sloped
slopped123511442slopped
slumped123710152slumped
slurped10368752slurped
snapped124611202snapped
sniped94913482sniped
snipped123510042snipped
soaped95817972soaped
souped95017672souped
spaed85522272s_paed
sped76031492s__ped
speed85526622s_peed
spied85427712s_pied
spued84918472s_pued
spumed114711542spumed
stepped123210052stepped
stiped94517072stiped
stoped94721012stoped
stopped124512202stopped
stumped124210152stumped
subbed114116672subbed
sucked134120492sucked
sudsed83911372sudsed
sued56537932su__ed
sueded84014632sueded
sughed113610202sughed
suited74019422suited
sulked114314702sulked
summed114014042summed
sunned74216322sunned
supe65932762su_pe_
super74924482su_per
supered10316122supered
supes75628302su_pes
suppers113314702suppers
supple10410202supple
suppler1148432suppler
supples11511282supples
supplied1345992supplied
supply1346892supply
supposed1345782supposed
surfed103814462surfed
surged84118882surged
suspend1036012suspend
sussed75015532sussed
swapped15429142swapped
swiped123811092swiped
swopped15437672swopped
tapped113820052tapped
tipped114418262tipped
topped114617722topped
tumped114216232tumped
umped104717272_umped
upper93714262_upper
urped84615282_urped
usurped1035152usurped
wapped144416472wapped
whupped18365412whupped
yapped144415142yapped
yipped143613282yipped
zapped204213522zapped
zipped203612982zipped

Search took 4 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 Filter178691825510.436409841.7
2DLD Change Limit825511313.08026802.3
3Display Results1311310.0462847.8
 (SQL Overall)1786911313.56250165.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.