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

345 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
heh9603962(None) 
eh58339961_eh
feh96136091feh
hah910655221hah
he58151951he_
hehs106723961hehs
hem86148731hem
hen67555271hen
hep86644141hep
her66547811her
hes66654201hes
het67674311het
heth107028021heth
hew97642721hew
hex137436171hex
hey96741061hey
huh96432011huh
peh86740961peh
yeh97135771yeh
aah616252962aah
ae212590292ae_
ah513868792_ah
ahed89536252ahed
ahem97225362ahem
ash67944602ash
bah87755352bah
be47948942be_
bed67950622bed
bee56262402bee
beg65944132beg
bel57148462bel
ben56554922ben
bes56557432bes
bet58376672bet
beth96629232beth
bey86645422bey
cee55952702cee
cel56040552cel
cep75736332cep
chef125125622chef
cheth135013822cheth
chew126622132chew
chez184519022chez
dah78148982dah
de37049542de_
deb66342692deb
dee47665822dee
def76546722def
del46752752del
den47554342den
dev76033772dev
dew77139922dew
dex116936882dex
dey77243372dey
duh77930382duh
ed38645182_ed
edh76921562edh
eek77935102eek
eel37946842eel
ef57345362_ef
el26745292_el
em49445152_em
en28052392_en
er28345142_er
es29048222_es
et26964192_et
eth66630982eth
ex98835642_ex
fe57944742fe_
fed76548352fed
fee66862012fee
fehs106522382fehs
fem86040732fem
fen66851352fen
fer66646122fer
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
foh98135892foh
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
ghee85726112ghee
ha510259942h_a
had77658762had
hae67364002hae
haed86338582haed
haem95730982haem
haen76229452haen
haes77651022haes
haet75659502haet
hag77255742hag
haha107821062haha
hahs108333362hahs
haj138140602haj
ham86363282ham
hao67251122hao
hap87360052hap
has67372652has
hash106936502hash
hat67289962hat
hath105933912hath
haw97153272haw
hay97358772hay
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heat77061422heat
heath115724282heath
hebe96424702hebe
heck135826492heck
heed86437602heed
heel75034222heel
heft106736292heft
heigh124812542heigh
heil76328932heil
heir77523802heir
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
heme95034412heme
hemp115725622hemp
hems95534942hems
hens75642572hens
hent76656382hent
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hest75950772hest
heths116317782heths
hets75547202hets
heuch135312332heuch
heugh125410922heugh
hewn106719852hewn
hews105631572hews
hi57947582h_i
hic86540562hic
hid76248372hid
hie67652702hie
hied85434042hied
hies74842832hies
high116619922high
him86247662him
hin67559562hin
hip86750432hip
his66359502his
hit66569192hit
hm78126732h_m
hmm106218992hmm
ho510258272h_o
hob87550922hob
hod76852462hod
hoe67562722hoe
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776062hot
how97252432how
hoy97447912hoy
hub86437482hub
hue66642302hue
hued86925852hued
hues75235232hues
hug76037362hug
hum85542932hum
hun65844712hun
hunh106323732hunh
hup86437812hup
hush105224112hush
hut66457292hut
hyp117822462hyp
ich86227742ich
jee106648642jee
jehu145614862jehu
jet106754822jet
jeu105532072jeu
jew135129082jew
kea76540912kea
kef105639662kef
keg86432532keg
ken76343982ken
kep96437202kep
kex146029582kex
key105833332key
khet116328622khet
kheth15509752kheth
lea37660182lea
lech96825442lech
led46254552led
lee36068142lee
leg46446112leg
lehr75514942lehr
lei36846382lei
lek75640302lek
les35663072les
let36481472let
leu36047402leu
lev66139422lev
lex107943822lex
ley66246812ley
lez125541312lez
me47748332me_
med66146742med
meg66040952meg
mel56047482mel
mem77943472mem
men59252852men
mesh96823002mesh
met56072432met
meth95827842meth
mew86137732mew
nah69847002nah
ne27045102ne_
neb57238622neb
nee36657782nee
neg47237342neg
net36670292net
new66237092new
noh66640642noh
nth66320592nth
oe28473062oe_
oes35866192oes
oh57447002_oh
ohed87825182ohed
okeh114615322okeh
ooh67637092ooh
pah88853592pah
pe47649032pe_
pea56657242pea
pec76744412pec
pech116125452pech
ped66751522ped
pee56066512pee
peg65843062peg
pehs95625762pehs
pen56558842pen
pep76447082pep
per56353092per
pes57259782pes
pet56477302pet
pew86442302pew
phew128417112phew
poh86740532poh
rah68052402rah
re26153742re_
reb55844962reb
rec55645462rec
red46755802red
ree37974072ree
ref66053292ref
reg46146492reg
rei35647252rei
rem56150042rem
rep55847802rep
res35565042res
resh76523452resh
ret35982832ret
rev65336622rev
rex105740992rex
rhea75017432rhea
sea36161292sea
sec55945322sec
see35772262see
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sh56828522_sh
shah105627782shah
she66837692she_
shea76031572shea
shed86536152shed
shes75734352shes
shew108030762shew
shh97121072shh
tea37353322tea
tech95925442tech
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
ten35856112ten
tet39274992tet
teth76327892teth
tew66640152tew
the67436052the_
thee78039062thee
them97427042them
then78429692then
thew108226232thew
they107223752they
ugh76520682ugh
uh57429852_uh
vee65750182vee
veg76931062veg
vet65958522vet
vex136429172vex
we57043452we_
web85735562web
wed75843622wed
wee66760812wee
wen66249602wen
wet65966622wet
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
yah99046352yah
ye57650062ye_
yea66445752yea
yeah106725412yeah
yech127220532yech
yen66847382yen
yep86638962yep
yes66250612yes
yet66960692yet
yew96436292yew
zed135431172zed
zee126143232zee
zek167323162zek
zep147129142zep

Search took 1 second 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.0463884587.0
2DLD Change Limit140843450.37337758.7
3Display Results3453450.0804312.5
 (SQL Overall)1786913450.499358098.2
 
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.