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

255 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
supe6593276(None) 
dupe76630601dupe
jupe134921001jupe
sipe67341041sipe
spue66025521spue
stupe75217751stupe
sue35651461su_e
sup57041941sup_
super74924481super
supes75628301supes
sups64834431sups
sure45447411sure
ape57251182_ape
bute66739672bute
cape87242782cape
cepe84926652cepe
cope86847382cope
coupe96023482coupe
cube85830212cube
cue57544182cu_e
cuke105824982cuke
cup76738242cup_
cupel9514302cupel
cups85430822cups
cure66149122cure
cute66440452cute
dope76038892dope
drupe85012992drupe
duce76933502duce
dude65629662dude
due45249862du_e
duke95628102duke
dune56137582dune
dup67637882dup_
duped95118322duped
duper85519002duper
dupes86425932dupes
duple85315862duple
dups75929512dups
dure56341812dure
fume96727632fume
fuse76429992fuse
fuze166422372fuze
gape75134512gape
gude65423332gude
hope96639672hope
hue66642302hu_e
huge86321652huge
hup86437812hup_
hype125519812hype
jape134923422jape
jube136322782jube
juke154721662juke
jupes145218552jupes
jute115327892jute
kue76631862ku_e
kune85424572kune
lipe66839732lipe
lope65941922lope
loupe75319512loupe
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lune47140492lune
lure45142462lure
lute46341012lute
luxe115222692luxe
mope86838042mope
mule65236972mule
mure65941332mure
muse67136032muse
mute65136872mute
nape65230802nape
nope65934192nope
nude56626272nude
nuke85920752nuke
ope56845242_ope
ouph95618372ouph
ouphe104413262ouphe
pe47649032__pe
pipe86434432pipe
pope85535612pope
puce85127882puce
puke105025462puke
pule65040952pule
pup76339882pup_
pupa85422812pupa
pupae96515642pupae
pups86032232pups
pupu87620712pupu
pure65543332pure
rape65041632rape
ripe66038922ripe
rope65542912rope
rube65532012rube
rude55632782rude
rue35549262ru_e
rule49938422rule
rune45236292rune
rupee7321282rupee
ruse45938932ruse
sabe66140572sabe
sade55544472sade
sae38365182s_ae
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954332sane
sap56463232sap_
saps65346372saps
sate45556102sate
sauce75121652sauce
saute55028082saute
save75741362save
scape96921842scape
scope94821482scope
scup84822382scup_
scups95316652scups
scute75520942scute
see35772262s_ee
seep66540342seep
seme65836652seme
sene46848052sene
sept65844362sept
sere46153472sere
shape105125112shape
she66837692s_he
shoe75933432shoe
shute84520342shute
sice65545592sice
side55444482side
sike87138782sike
sine46560622sine
sip57656012sip_
siped84927682siped
sipes76036952sipes
sips65740102sips
sire46150412sire
site47052412site
size135630962size
skee85431472skee
skep105219352skep
slipe75626132slipe
sloe45534952sloe
slope75823562slope
slue45332192slue
slype105112362slype
snipe75320572snipe
snye77115492snye
soke85436262soke
sole46053672sole
some66040382some
sone46649982sone
sop57557862sop_
soph97024202soph
sops65244562sops
sore47059532sore
soup66232912soup_
souped95017672souped
soups75322942soups
soupy106115402soupy
souse56530772souse
spa55730812s_pa
spae65034322spae
spec85821972s_pec
sped76031492s_ped
spew95421872s_pew
spud75818492spud
spued84918472spued
spues75025382spues
spume95817312spume
spun66221462spun
spur65321192spur
spy86023742s_py
step67126292step
stipe76523372stipe
stope74727242stope
stupa74112312stupa
stupes84116952stupes
stye76218972stye
suave83519872suave
sub55445552su_b
suba64926602suba
suber74924502suber
subs66037122subs
such96424812such
suck106131732suck
sucre75019102sucre
sudd64719772sudd
suds56135292suds
sued56537932sued
suede64419752suede
suer45334032suer
sues46247652sues
suet46754822suet
sugh86423442sugh
suit45649872suit
suite54829562suite
suk75632972su_k
suks85927122suks
sulk85326652sulk
sulu45128422sulu
sum56346012su_m
sumo67326312sumo
sump86331532sump
sumps95023432sumps
sums65837582sums
sun37149032su_n
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
superb104410992superb
supers84622402supers
supine84216692supine
supped114415702supped
supper104115432supper
supple10410202supple
supra73614252supra
suq126228992su_q
suqs134319652suqs
sura45740292sura
surd56433812surd
surer54833092surer
surf76039312surf
surge65027692surge
suss45229302suss
swipe105217082swipe
syce95820282syce
syke115420562syke
syne75725762syne
syph125413272syph
tape64538142tape
taupe7314162taupe
tope65946382tope
tube65828662tube
tule45735872tule
tune45635862tune
tup56037542tup_
tups65628762tups
type96223742type
uke75727292_uke
up47832822_up_
upo58925862_upo
ups55629052_ups
use36835162_use
ute35335882_ute
wipe94830282wipe
yipe96722172yipe
yule75725142yule
yup86031702yup_
yups96121602yups

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 Filter178691298720.0802233637.5
2DLD Change Limit298722550.92032469.6
3Display Results2552550.0634047.6
 (SQL Overall)1786912551.063168100.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.