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

145 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
thaws11651546(None) 
chaws135022461chaws
haws106439441_haws
shaws116226261shaws
taws75641591t_aws
thaw107521311thaw_
thews117416191thews
thraws129211101thraws
blaws105620462blaws
braws106425192braws
caws96036112_caws
chads116122232chads
chais107530312chais
chams126028502chams
chaos105622862chaos
chaps125326062chaps
chars105936642chars
chats105730092chats
chaw126224632chaw_
chays135319742chays
chews135418512chews
chows135618202chows
claws106020832claws
craws105723122craws
daws86638242_daws
dhaks13479702dhaks
dhals95415442dhals
dhows125911222dhows
draws95119372draws
flaws115920342flaws
ghats95818612ghats
gnaws96311142gnaws
haes77651022_haes
hags86740842_hags
hahs108333362_hahs
hams96446132_hams
haps96443462_haps
has67372652_ha_s
hats76858252_hats
haw97153272_haw_
hawk145521152_hawk
hawks155415702_hawks
hawse116015122_hawse
hays106138072_hays
hews105631572_hews
hows106345602_hows
jaws145027292_jaws
khafs15648842khafs
khans124615172khans
khats125316012khats
laws76441682_laws
maws96437142_maws
paws96038182_paws
pshaws14435702pshaws
raws75238212_raws
saws75839482_saws
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shaw108132552shaw_
shawl116217572shawl
shawls125411972shawls
shawm135316152shawm
shawms14579562shawms
shawn116417612shawn
shays116021432shays
shews115924712shews
shows115324582shows
shwas116415102shwas
slaws85222712slaws
snaws86116362snaws
straws98718672straws
tabs66842982t_abs
tads57143942t_ads
tags55545242t_ags
tahrs85412332tahrs
tams67247932t_ams
tans46154832t_ans
taos45541002t_aos
taps66050682t_aps
tars46763952t_ars
tas38477102t_a_s
tass45640572t_ass
tats46858132t_ats
taus46342732t_aus
tavs75630972t_avs
taw610155452t_aw_
tawse85616502t_awse
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
tews76431642t_ews
thack144915172thack
thacks154311922thacks
thae76825562tha_e
than76128772tha_n
thane86122532thane
thanes94918982thanes
thank125817802thank
thanks134313132thanks
tharm105916642tharm
tharms115712242tharms
that75639322tha_t
thawed13458462thawed
thawer12489342thawer
thawers13428482thawers
thens85921832thens
thew108226232thew_
thewy146311852thewy
thins85826332thins
this76027382th_is
thous86017262thous
thraw1110515922thraw_
thrawn12769422thrawn
throws129715232throws
thuds95110132thuds
thugs95611992thugs
thus76721472th_us
toads65621072toads
tows78545552t_ows
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trawl84915872trawl
trawls94412392trawls
trays85623432trays
trews86118892trews
trows88826182trows
tsars56717112tsars
twaes86513662twaes
twas76824082twa_s
twats86616602twats
tzars144914272tzars
vaws105527322_vaws
waws106834902_waws
whams135515642whams
whaps135115162whaps
whats117718992whats
whews145114492whews
yaws105531212_yaws

Search took 3 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.310576422.6
2DLD Change Limit538001451.75030742.9
3Display Results1451450.0334393.9
 (SQL Overall)1786911452.09385375.5
 
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.