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

199 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
whats11771899(None) 
chats105730091chats
ghats95818611ghats
hats76858251_hats
khats125316011khats
wats77555881w_ats
whams135515641whams
whaps135115161whaps
what105434071what_
wheats125013221wheats
whets115019611whets
whits115923821whits
arhats9312972arhats
bahts105617802bahts
bats66962332_bats
beats76042242beats
bhuts105812952bhuts
blats75132502blats
boats75635152boats
brats75336012brats
cats66356342_cats
chads116122232chads
chais107530312chais
chams126028502chams
chants115020392chants
chaos105622862chaos
chaps125326062chaps
chars105936642chars
charts115823092charts
chat95546132chat_
chaws135022462chaws
chays135319742chays
cheats114519542cheats
chits105424572chits
coats75635002coats
dhaks13479702dhaks
dhals95415442dhals
doats65224882doats
drats66628372drats
eats47054872_eats
fats76252502_fats
feats86432752feats
fiats85324482fiats
flats86429742flats
frats86829672frats
gats56753442_gats
ghast95621222ghast
ghat86435282ghat_
ghauts10447782ghauts
gnats65217712gnats
goats65527302goats
haes77651022_haes
haets86525122_haets
hafts116219462_hafts
hags86740842_hags
hahs108333362_hahs
halts85230102_halts
hams96446132_hams
hants86335402_hants
haps96443462_haps
harts88441592_harts
has67372652_ha_s
hast76259482_hast
hat67289962_hat_
hate78450172_hate
hates86742572_hates
hath105933912_hath
haws106439442_haws
hays106138072_hays
heats85838402heats
hets75547202_hets
hits75545132_hits
hots78349332_hots
huts76737442_huts
ikats95311152ikats
kats85944332_kats
khafs15648842khafs
khans124615172khans
khat116730722khat_
khets124913432khets
kyats125012442kyats
lats45962702_lats
mats65460292_mats
meats75034052meats
moats75827642moats
neats55931902neats
oats46554212_oats
pats66460852_pats
peats76140192peats
phat95837862phat_
phots105418502phots
phuts104613502phuts
plats75531372plats
prats76333392prats
qats135331342_qats
rats46260372_rats
scats75930602scats
seats54844342seats
shads95124482shads
shafts125411442shafts
shags95123862shags
shahs115919512shahs
shams105829412shams
shat76456602shat_
shaws116226262shaws
shays116021432shays
shits84731172shits
shoats94117082shoats
shots84730852shots
shuts85622482shuts
skats94621542skats
slats55436902slats
spats75031382spats
stats55933362stats
swats85726862swats
sweats94814612sweats
tats46858132_tats
teats55636812teats
that75639322that_
thaws116515462thaws
twats86616602twats
unhats91110622unhats
vats76841742_vats
wabs97337232w_abs
wads87343142w_ads
waes76048602w_aes
wafts116920552wafts
wags86140552w_ags
waits88333522waits
wans76452272w_ans
wants87932212wants
waps96642082w_aps
wars78659802w_ars
warts814840402warts
was68767562w_a_s
wast75655852w_ast
wasts87433672wasts
wat67378922w_at_
watt75545412w_att
watts86923092watts
waws106834902w_aws
ways107737952w_ays
weals85428742weals
weans85326742weans
wears86030302wears
weets85427722weets
wefts116715492wefts
welts85225192welts
wests85727002wests
wets75940292w_ets
wha96422072wha__
whack174813022whack
whacks184610482whacks
whale115517432whale
whales124716942whales
wham125321692wha_m
whamo135511262whamo
whang124813382whang
whangs13439722whangs
whap125119642wha_p
wharf14315822wharf
wharfs1546372wharfs
whatsis1335252whatsis
whatsit1345822whatsit
whaup13458882whaup
whaups14405752whaups
wheals124512522wheals
wheat114924572wheat_
whens114618762whens
whet105133782whet_
whews145114492whews
wheys145911552wheys
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whips134917082whips
whirs115218092whirs
whist115322952whist
whists124613812whists
whit104834172whit_
white114920302white
whites123919882whites
whity145513472whity
whops135013932whops
whorts125111432whorts
whups134210002whups
whys137011662wh_ys
wilts85023502wilts
wists86728522wists
wits76044872w_its
woads94818442woads
wonts87621542wonts
worts88631182worts
wots76342892w_ots
wraps105617152wraps
wrath115715872wrath
wraths123810082wraths
writs86624382writs

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.310576422.6
2DLD Change Limit538001991.47036598.6
3Display Results1991990.0633158.7
 (SQL Overall)1786911991.84396956.6
 
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.