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

324 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
haet7565950(None) 
hae67364001hae_
haed86338581haed
haem95730981haem
haen76229451haen
haes77651021haes
haets86525121haets
haft105941841haft
halt76056301halt
hant75461581hant
hart76865771hart
hast76259481hast
hat67289961ha_t
hate78450171hate
haut75949731haut
heat77061421heat
het67674311h_et
abet610547942abet
act59557842_act
ae212590292_ae_
aft66849012_aft
ahed89536252ahed
ahem97225362ahem
ait38093902_ait
alt36467962_alt
ant37270782_ant
apt57352542_apt
art38679142_art
at212393402_a_t
ate37059242_ate
att35454652_att
baht96740012baht
bait66556002bait
bast66362412bast
bat510988952ba_t
bate66552422bate
batt65053872batt
beat66168302beat
beet66457542beet
bet58376672_bet
blet66247672blet
cadet85339332cadet
cant66362022cant
caret75360562caret
cart66570342cart
cast67159902cast
cat58282342ca_t
cate66254592cate
chaeta11310682chaeta
chalet113825992chalet
chant105932692chant
chapt125827642chapt
chart105038282chart
chat95546132cha_t
cheat105732452cheat
daft85537252daft
dart55857872dart
date56443322date
daut56443562daut
dawt85435942dawt
deet57356582deet
diet57357532diet
duet56446262duet
east46659102east
eat36989052ea_t
et26964192__et
facet106038522facet
fact97142542fact
fart76860562fart
fast77052312fast
fat68178082fa_t
fate75444282fate
feat76458222feat
feet75352212feet
fet66471632_fet
fret75845042fret
gae46457702gae_
gaed66031512gaed
gaen57329602gaen
gaes56348032gaes
gait56150192gait
gast56052562gast
gat46880512ga_t
gate55746572gate
get47467462_get
ghast95621222ghast
ghat86435282gha_t
ghaut95919432ghaut
ha510259942ha__
haaf106227732haaf
haar77323492haar
habit103027012habit
habu97325482habu
hacek145411842hacek
hack135134542hack
had77658762ha_d
hade85440192hade
haded105227622haded
hades96035112hades
hadj155818672hadj
hadst93220222hadst
haems105517012haems
haffet15311702haffet
hafts116219462hafts
hag77255742ha_g
hags86740842hags
hah910655222ha_h
haha107821062haha
hahs108333362hahs
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
haj138140602ha_j
hajes155420942hajes
haji148520182haji
hajj138312472hajj
hake115637842hake
hakes126034302hakes
haku116923892haku
hale76052832hale
haled95335822haled
haler85033522haler
hales85449842hales
halest94823272halest
half106238452half
hall75741162hall
halm95834972halm
halo76437322halo
halts85230102halts
ham86363282ha_m
hame97043132hame
hames106138702hames
hamlet113722792hamlet
hams96446132hams
hand86833702hand
hang85535542hang
hank115134132hank
hants86335402hants
hao67251122ha_o
hap87360052ha_p
haps96443462haps
hard85443502hard
hare76255732hare
hared95742182hared
harem104924452harem
hares86255542hares
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
harts88441592harts
has67372652ha_s
hash106936502hash
haslet93222712haslet
hasp96627292hasp
haste85927862haste
hasty115718762hasty
hated95734022hated
hater85034752hater
hates86742572hates
hath105933912hath
hats76858252hats
haul75530452haul
haunt85229132haunt
haute89521612haute
have106137072have
haven114718532haven
haver115124462haver
haves116034872haves
haw97153272ha_w
hawed126025422hawed
hawk145521152hawk
haws106439442haws
hay97358772ha_y
hayed125822012hayed
hayer114620242hayer
hayey144812532hayey
hays106138072hays
haze164833392haze
hazed185222202hazed
hazel176414812hazel
hazer174820232hazer
hazes174928322hazes
hazy1918119192hazy
he58151952h_e_
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heart85440742heart
heath115724282heath
heats85838402heats
heed86437602heed
heel75034222heel
heft106736292heft
heh96039622h_eh
hem86148732h_em
hen67555272h_en
hent76656382hent
hep86644142h_ep
her66547812h_er
hes66654202h_es
hest75950772hest
heth107028022h_eth
hets75547202h_ets
hew97642722h_ew
hex137436172h_ex
hey96741062h_ey
hie67652702hie_
hied85434042hied
hies74842832hies
hilt75850712hilt
hint77455742hint
hist76551542hist
hit66569192h_it
hoe67562722hoe_
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
holt77852582holt
hoot75752092hoot
host77852832host
hot67776052h_ot
hue66642302hue_
hued86925852hued
hues75235232hues
hunt76445492hunt
hurt77142572hurt
hut66457292h_ut
hyte109018942hyte
jet106754822_jet
kae76744542kae_
kaes85734062kaes
kart86750802kart
kat77468292ka_t
keet85347332keet
khat116730722kha_t
khet116328622khet
last46260322last
lat37593402la_t
late47560482late
leet45957902leet
let36481472_let
mae57659102mae_
maes66948392maes
malt66254802malt
mart66865972mart
mast65959952mast
mat58083932ma_t
mate65154212mate
matt65752652matt
maut65448442maut
meat66359602meat
meet65350552meet
met56072432_met
nae35952742nae_
neat46356782neat
net36670292_net
oast47156322oast
oat39888262oa_t
pact86648722pact
palet74650802palet
pant66061252pant
part65967462part
past65959012past
pat58089462pa_t
pate65350462pate
peat65967932peat
pet56477302_pet
phat95837862pha_t
poet65552902poet
qat125253332qa_t
raft76245912raft
ramet75743142ramet
rant45864672rant
rapt67245312rapt
rat37892742ra_t
rate45458762rate
ret35982832_ret
sae38365182sae_
salt45758522salt
sat36288482sa_t
sate45556102sate
seat47575562seat
set36681252_set
shaft115725252shaft
shalt85534482shalt
shat76456592sha_t
sheet84836952sheet
stet45947322stet
suet46754822suet
tacet75840022tacet
tact67349032tact
tae38267052tae_
tael46030712tael
tart47566182tart
tat37690292ta_t
tate44748602tate
taut47048962taut
teat45963632teat
tet39274982_tet
thae76825562thae_
that75639322tha_t
tret46653532tret
valet84337872valet
vast75045122vast
vat67863452va_t
vet65958522_vet
wae67556952wae_
waes76048602waes
waft106139002waft
wait75553692wait
want76156162want
wart77866082wart
wast75655852wast
wat67378922wa_t
watt75545412watt
weet75254152weet
wet65966622_wet
what105434072wha_t
wheat114924572wheat
whet105133782whet
yet66960692_yet

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.0632836365.1
2DLD Change Limit298723240.92032469.6
3Display Results3243240.0804050.0
 (SQL Overall)1786913241.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.