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

220 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
hawk14552115(None) 
dawk126117281dawk
gawk126716691gawk
hack135134541hack
haik115526981haik
hank115134141hank
hark115237391hark
haw97153271haw_
hawks155415701hawks
haws106439441haws
howk145221961howk
ark77044962_ark
ask77130702_ask
auk76234142_auk
aw512563402_aw_
awa611939672_awa
awe67746622_awe
awl67635302_awl
awn68035912_awn
back125535762back
balk105132222balk
bank105835752bank
bark106242152bark
bask105131422bask
bawd105520842bawd
bawl95326062bawl
calk105527662calk
cark105539272cark
cask105626432cask
caw86647932caw_
caws96036112caws
chalk144814602chalk
chark144222712chark
chaw126224632chaw_
chaws135022462chaws
dak86340692da_k
dank95828242dank
dark95133212dark
daw77148362daw_
dawks135213492dawks
dawn85624202dawn
daws86638242daws
dawt85435942dawt
dhak125512032dha_k
fawn105321952fawn
gawks136811632gawks
gawky16569992gawky
gawp107618632gawp
gowk125516472gowk
ha510259942ha__
haaf106227732haaf
haar77323492haar
habu97325482habu
hacek145411842hacek
hacks144928712hacks
had77658762ha_d
hade85440192hade
hadj155818672hadj
hae67364002ha_e
haed86338582haed
haem95730982haem
haen76229452haen
haes77651022haes
haet75659502haet
haft105941842haft
hag77255742ha_g
hags86740842hags
hah910655222ha_h
haha107821062haha
hahs108333362hahs
haika125313792haika
haiks125120932haiks
haiku126113692haiku
hail74839062hail
hair76330142hair
haj138140602ha_j
haji148520192haji
hajj138312472hajj
hake115637842hake
haku116923892haku
hale76052832hale
half106238452half
hall75741162hall
halm95834972halm
halo76437322halo
halt76056302halt
ham86363282ha_m
hame97043132hame
hams96446132hams
hand86833712hand
hang85535552hang
hanks126226862hanks
hanky155418292hanky
hant75461592hant
hao67251122ha_o
hap87360052ha_p
haps96443462haps
hard85443502hard
hare76255732hare
harks126333432harks
harl75740002harl
harm95637792harm
harp96134292harp
hart76865772hart
has67372652ha_s
hash106936502hash
hasp96627292hasp
hast76259482hast
hat67289962ha_t
hate78450172hate
hath105933912hath
hats76858252hats
haul75530452haul
haut75949732haut
have106137072have
hawed126025422hawed
hawked174712672hawked
hawker164812662hawker
hawkey19507632hawkey
hawkie163810092hawkie
hawse116015122hawse
hay97358772ha_y
hays106138072hays
haze164833392haze
hazy1918119192hazy
heck135826492heck
hew97642722hew_
hewn106719852hewn
hews105631572hews
hick135530302hick
hock136031302hock
holk116027942holk
honk116931192honk
hook116133282hook
how97252432how_
howe106734102howe
howf136127202howf
howks155016852howks
howl107625692howl
hows106345602hows
huck135927632huck
hulk115321612hulk
hunk116029542hunk
husk116021952husk
hwan105716892hwan
jack175224862jack
jauk155816092jauk
jaw136237682jaw_
jaws145027292jaws
lack105837682lack
lank84734452lank
lark85733862lark
law68656642law_
lawn75925632lawn
laws76441682laws
mack125733652mack
mark105138062mark
mask105227362mask
maw87050102maw_
mawn94424142mawn
maws96437142maws
mohawk1842072mohawk
nark85230062nark
naw66346492naw_
oak76238652oa_k
pack125535442pack
paik105726802paik
park105237492park
paw87651172paw_
pawky173810152pawky
pawl95123262pawl
pawn94625302pawn
paws96038182paws
rack106234882rack
rank85135532rank
raw67252252raw_
raws75238212raws
sack105337312sack
sank85236832sank
sark84938972sark
saw68255352saw_
sawn75428162sawn
saws75839482saws
shack145321752shack
shank125422192shank
shark126225022shark
shaw108132552shaw_
shawl116217572shawl
shawm135316152shawm
shawn116417612shawn
shaws116226262shaws
tack106536292tack
talk86230092talk
tank85134022tank
task85326652task
taw610155452taw_
taws75641592taws
thack144915172thack
thank125817802thank
thaw107521312thaw_
thaws116515462thaws
vaw95937462vaw_
vaws105527322vaws
wack135330912wack
walk115625612walk
wank115632512wank
wark115737772wark
wauk115220592wauk
waw97046382waw_
wawl105321942wawl
waws106834902waws
whack174813022whack
yack135425972yack
yak107038562ya_k
yank115423672yank
yaw97145152yaw_
yawl104918972yawl
yawn106219092yawn
yawp125215582yawp
yaws105531212yaws

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.283631417.0
2DLD Change Limit298722200.78038297.4
3Display Results2202200.0464782.6
 (SQL Overall)1786912201.109161128.0
 
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.