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

184 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
hyp11782246(None) 
gyp98319011gyp
hap87360051hap
hep86644141hep
hip86750441hip
hop87554591hop
hup86437811hup
hype125519811hype
hypo127516351hypo
hyps125418411hyps
alp56641132alp
amp77541022amp
app76827602app
asp57235342asp
ay511773892ay_
aye67151762aye
ays67050292ays
bap76455842bap
bop77549482bop
by77529232by_
bye86134592bye
bys85229462bys
cap76758982cap
cep75736332cep
chap114928492chap
chip116726422chip
chop116024922chop
cop711162372cop
cup76738242cup
dap66652452dap
dip67848992dip
dup67637882dup
dye75334842dye
eye65539772eye
fop86743702fop
gap67055612gap
gip67645372gip
gym95719062gym
gyps105115022gyps
ha510259942h_a
had77658772had
hae67364002hae
hag77255742hag
hah910655222hah
haj138140602haj
ham86363282ham
hao67251122hao
haps96443462haps
harp96134292harp
has67372652has
hasp96627292hasp
hat67289962hat
haw97153272haw
hay97358772hay
hays106138072hays
he58151952h_e
heap96432892heap
heh96039622heh
help95328922help
hem86148732hem
hemp115725622hemp
hen67555272hen
her66547812her
hes66654202hes
het67674312het
hew97642722hew
hex137436172hex
hey96741062hey
hi57947592h_i
hic86540572hic
hid76248392hid
hie67652712hie
him86247672him
hin67559572hin
hips96433712hips
his66359512his
hit66569202hit
hm78126732h_m
hmm106218992hmm
ho510258272h_o
hob87550922hob
hod76852472hod
hoe67562722hoe
hog78049062hog
holp95727552holp
hon67759382hon
hoop96129982hoop
hope96639672hope
hops97942632hops
hos68364192hos
hot67776062hot
how97252432how
hoy97447912hoy
hoya107418372hoya
hoys107733932hoys
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hump116228722hump
hun65844712hun
hut66457292hut
hyla106716512hyla
hymn12311312hymn
hyped145313332hyped
hyper135213902hyper
hypes135818672hypes
hypha1637382hypha
hypos1312014742hypos
hyte109018942hyte
imp76626982imp
kep96437212kep
kip97042152kip
kop97440212kop
kye107327282kye
lap58565272lap
lip514755812lip
lop58255312lop
lye66533412lye
map77255122map
mop76950822mop
my78125652my_
myc106519502myc
nap56753202nap
nip56945992nip
op45850162_op
oy58950132oy_
pap76758402pap
pep76447082pep
pip78051052pip
pop76252252pop
pup76339882pup
pya87023752pya
pye86432502pye
pyx157817012pyx
rap56261962rap
rep55847802rep
rip56851312rip
rya67622012rya
rye66032542rye
sap56463232sap
ship95228242ship
shop95629842shop
shy96728192shy_
sip57656022sip
sop57557862sop
spy86023742spy
sup57041942sup
syn67024122syn
syph125413272syph
tap57663882tap
thy97022912thy_
tip56551232tip
top510560682top
tup56037542tup
tye65837442tye
type96223742type
typo95418122typo
typp115812782typp
typy126013042typy
ump76130442ump
up47832822_up
urp56426402urp
wap86553372wap
whap125119642whap
whip125521842whip
whop125520922whop
whup125714162whup
why126920012why_
whys137011662whys
wop87145132wop
wye96331972wye
wyn95921442wyn
ya510251502_ya
yap85949822yap
ye57650062_ye
yep86638962yep
yip87241192yip
yo59748552_yo
yup86031702yup
zap145840692zap
zep147129142zep
zip146636232zip

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 Filter178691140840.593301333.9
2DLD Change Limit140841840.81317323.5
3Display Results1841840.0762421.1
 (SQL Overall)1786911841.482120574.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.