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

259 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
haets8652512(None) 
haems105517011haems
haes77651021hae_s
haet75659501haet_
hafts116219461hafts
halts85230101halts
hants86335401hants
harts88441591harts
hates86742571hates
hats76858251ha_ts
heats85838401heats
hets75547201h_ets
abets75621672abets
acts66929862_acts
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
ates45047922_ates
bahts105617802bahts
baits76630582baits
basts75936932basts
bates75846342bates
bats66962332ba_ts
batts76727562batts
beats76042242beats
beets76131442beets
bets67051442_bets
blets75324942blets
cadets96316502cadets
cants77036942cants
carets85330772carets
carts78946292carts
casts77237792casts
cates75951872cates
cats66356342ca_ts
chaeta11310682chaeta
chalets122813472chalets
chants115020392chants
charts115823092charts
chats105730092cha_ts
cheats114519542cheats
darts67635732darts
dates65639152dates
dauts67822242dauts
dawts97216122dawts
deets65330242deets
diets66026642diets
duets65323882duets
easts57530322easts
eats47054872ea_ts
facets116316652facets
facts107021892facts
farts88336842farts
fasts86429682fasts
fates85139232fates
fats76252502fa_ts
feats86432752feats
fets75345942_fets
frets85523402frets
gaes56348032gae_s
gaits65726012gaits
gasts66628632gasts
gates65939502gates
gats56753442ga_ts
gets55442482_gets
ghats95818612gha_ts
ghauts10447782ghauts
haafs115711162haafs
haars85620472haars
habits113014642habits
habus106317142habus
haceks15447862haceks
hacks144928712hacks
hades96035112hades
hadst93220222hadst
hae67364002hae__
haed86338582hae_d
haem95730982hae_m
haen76229452hae_n
haeres94017032haeres
haffets1636052haffets
haft105941842haft_
hags86740842ha_gs
hahas117118442hahas
hahs108333362ha_hs
haiks125120932haiks
hails85231642hails
haints94417582haints
hairs86225172hairs
hajes155420942hajes
hajis156716272hajis
hakes126034302hakes
hakus125114112hakus
halers94926912halers
hales85449842hales
halest94823272halest
halls85633782halls
halms105225212halms
halos85230252halos
halt76056302halt_
hames106138702hames
hamlets123211402hamlets
hams96446132ha_ms
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hant75461582hant_
haps96443462ha_ps
hards96435652hards
harems115513822harems
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
hart76865772hart_
has67372652ha__s
haslets102510862haslets
hasps105114642hasps
hast76259482hast_
haste85927862haste
hastes95727072hastes
hasty115718762hasty
hat67289962ha_t_
hate78450172ha_te
hated95734022hated
hater85034752hater
haters94930392haters
hath105933912ha_th
hauls86123732hauls
haunts95614392haunts
haut75949732haut_
haute89521612haute
havens124514042havens
havers124721482havers
haves116034872haves
hawks155415702hawks
haws106439442ha_ws
hayers124415942hayers
hays106138072ha_ys
hazels185710082hazels
hazers184615952hazers
hazes174928322hazes
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
hearts96218942hearts
heat77061422heat_
heath115724282heath
heaths126316382heaths
heeds95420422heeds
heels85625532heels
hefts116218152hefts
hehs106723962h_ehs
hems95534942h_ems
hens75642572h_ens
hents87330742hents
hers75844872h_ers
hes66654202h_e_s
hest75950772h_est
hests85829932hests
het67674312h_et_
heth107028022h_eth
heths116317782h_eths
hews105631572h_ews
hies74842832hie_s
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132h_its
hoers85724922hoers
hoes75755732hoe_s
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322h_ots
hues75235232hue_s
hunts86826172hunts
hurts86922822hurts
huts76737442h_uts
jets115834102_jets
kaes85734062kae_s
karts97630112karts
kats85944332ka_ts
keets95123482keets
khats125316012kha_ts
khets124913432khets
lasts57731262lasts
lats45962702la_ts
leets54927122leets
lets47147942_lets
maes66948392mae_s
malts76331752malts
marts77442232marts
masts77035762masts
mates75251362mates
mats65460282ma_ts
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
nates55238332nates
neats55931902neats
nets45941532_nets
oasts56529182oasts
oats46554212oa_ts
pacts95125802pacts
palets85122312palets
pants76536922pants
parts77743372parts
pasts75936502pasts
pates76047892pates
pats66460852pa_ts
peats76140192peats
pets66248332_pets
poets76024442poets
qats135331342qa_ts
rafts87820632rafts
ramets83517392ramets
rants55935342rants
rates55352012rates
rats46260372ra_ts
rets45352562_rets
salts55431882salts
sates54949322sates
seats54844342seats
sets45549502_sets
shafts125411432shafts
sheets93918492sheets
stets55423912stets
suets55126102suets
tacts76524122tacts
taels56822072taels
tarts57242022tarts
tates55444982tates
tats46858132ta_ts
tauts56125512tauts
teats55636812teats
tets45847452_tets
trets55928022trets
valets93715622valets
vasts86423772vasts
vats76841742va_ts
vets76835092_vets
waes76048602wae_s
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
weets85427722weets
wets75940292_wets
whats117718992wha_ts
wheats125013222wheats
whets115019612whets

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.0931921408.6
2DLD Change Limit538002591.68631909.8
3Display Results2592590.0803237.5
 (SQL Overall)1786912591.85996122.1
 
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.