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

179 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
super7492448(None) 
duper85519001duper
suber74924501suber
suer45334031su_er
supe65932761supe_
superb104410991superb
supers84622401supers
supes75628301supes
supper104115431supper
surer54833101surer
aper66336232_aper
asper75520432asper
auger64922472auger
bumper123714342bumper
buyer105013092buyer
caper94831622caper
coper95336092coper
cuber95222532cuber
cupel9514302cupel
cupper124313862cupper
curer75030752curer
cuter74728232cuter
doper86128392doper
dumper114615212dumper
dupe76630602dupe_
duped95118322duped
dupers94615602dupers
dupery12378742dupery
dupes86425932dupes
fumer105918232fumer
gaper86125122gaper
gulper93410212gulper
hoper105829142hoper
huger94914872huger
humper134115882humper
hyper135213902hyper
japer146218882japer
jumper173612372jumper
jupe134921002jupe_
jupes145218552jupes
leper74820742leper
loper75129232loper
luger65322082luger
lumper103816652lumper
lurer54625312lurer
moper94925922moper
mumper123513522mumper
muser76024122muser
muter74525542muter
nuder66416832nuder
outer55633302outer
paper95128662paper
pauper103511942pauper
per56353092__per
piper96523192piper
puler74826622puler
pulper103513272pulper
pumper124415552pumper
purer75127902purer
queer143712812queer
raper74932752raper
riper74328402riper
roper75431912roper
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
rupee7321282rupee
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
sapor75119252sapor
sapper103822352sapper
saucer84314102saucer
sauger74316252sauger
saver84831252saver
sawer85026212sawer
sayer84926552sayer
scauper11379452scauper
scupper1367422scupper
seder64826762seder
seer45547042s_eer
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
shaper114119932shaper
sheer84726892sheer
shier85428942shier
shoer84722162shoer
shyer114714782shyer
siker95326032siker
simper103616292simper
sipe67341042sipe_
siped84927682siped
sipes76036952sipes
sipper103920992sipper
siver85728612siver
sizer145521812sizer
skier95119592skier
slier54827242slier
sloper84615912sloper
slyer85515122slyer
sneer54919952sneer
sniper84413642sniper
soaper84517872soaper
sober74822412sober
sopor74016492sopor
sorer56236592sorer
souped95017672souped
soupier93111752soupier
sourer63620212sourer
souter64225922souter
sower85229312sower
spar65433302s_par
spear75821062s_pear
spec85821972s_pec
sped76031492s_ped
speer74623902speer
speir75315362s_peir
sperm93216022s_perm
spew95421872s_pew
spier75728032spier
spue66025522spue_
spued84918472spued
spues75025382spues
spur65321192s_pur
steer55423862steer
stoper84320102stoper
stumper113610092stumper
stupe75217752stupe_
stupes84116952stupes
stupor836012stupor
suaver93014232suaver
subers85722642subers
subpar1048662subpar
sucker124120662sucker
sucre75019102sucre
sudor6312622sudor
sudser73511282sudser
sue35651462su_e_
sued56537932su_ed
suers55128482su_ers
sues46247652su_es
suet46754822su_et
suffer124314512suffer
sugar6312912sugar
suiter64121812suiter
sulker104015922sulker
summer104017712summer
sumpter1138872sumpter
sunder74019822sunder
sup57041942sup__
supered10316122supered
supped114415702supped
suppers113314702suppers
suppler1148432suppler
supra73614252supra
sups64834432sup_s
sure45447412sure_
surfer93515882surfer
surger74320092surger
sutler63718392sutler
sweer84918572sweer
sypher14317082sypher
taper74829772taper
toper75231022toper
tuber75420682tuber
tuner56022682tuner
tuyer85414292tuyer
upper93714262upper
user45023002_user
usher84517762usher
usurer638102usurer
usurper934352usurper
viper105017302viper
wiper105421292wiper
yauper11368542yauper

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001791.39038705.0
3Display Results1791790.0463891.3
 (SQL Overall)1786911791.749102167.5
 
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.