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

171 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
whets11501961(None) 
hets75547201_hets
khets124913431khets
weets85427721weets
wets75940291w_ets
whats117718991whats
wheats125013221wheats
whens114618761whens
whet105133781whet_
whews145114491whews
wheys145911551wheys
whits115923821whits
abets75621672abets
beets76131442beets
bets67051442_bets
bhuts105812952bhuts
blets75324942blets
chats105730092chats
cheats114519542cheats
chefs136214662chefs
cherts115617232cherts
chess105016922chess
chest104926142chest
chests114916262chests
cheth135013822cheth
cheths14389822cheths
chews135418512chews
chits105424572chits
deets65330242deets
diets66026642diets
duets65323882duets
fets75345942_fets
frets85523402frets
gets55442482_gets
ghats95818612ghats
ghees95215552ghees
haets86525122haets
hats76858252_hats
heats85838402_heats
hefts116218152_hefts
hehs106723962_hehs
hems95534942_hems
hens75642572_hens
hents87330742_hents
hers75844872_hers
hes66654202_he_s
hest75950772_hest
hests85829932_hests
het67674312_het_
heth107028022_heth
heths116317782_heths
hews105631572_hews
hits75545132_hits
hots78349332_hots
huts76737442_huts
jets115834102_jets
keets95123482keets
khats125316012khats
khet116328622khet_
kheth15509752kheth
kheths16495972kheths
leets54927122leets
lets47147942_lets
meets74224612meets
nets45941532_nets
owlets93110392owlets
pets66248332_pets
phots105418502phots
phuts104613502phuts
poets76024442poets
rets45352562_rets
rheas84816952rheas
sets45549502_sets
sheas86331792sheas
sheds96122702sheds
sheets93918502sheets
shes75734352she_s
shews115924712shews
shits84731172shits
shots84730852shots
shuts85622482shuts
stets55423912stets
suets55126102suets
sweets94214432sweets
tets45847462_tets
thefts12387922thefts
thens85921832thens
theta83414572theta
thetas93011572thetas
thews117416192thews
trets55928022trets
tweets94210102tweets
vets76835092_vets
waes76048602wae_s
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882w_ats
watts86923092watts
webs96622122w_ebs
weds86628932w_eds
weeds95222212weeds
weeks125017862weeks
weens85224052weens
weeps104120562weeps
wees76249122w_ees
weest85026772weest
weet75254152weet_
wefts116715492wefts
welts85225192welts
wens76337932w_ens
west75748082w_est
wests85727002wests
wet65966622w_et_
whams135515642whams
whaps135115162whaps
what105434072what_
wheal115716182wheal
wheals124512522wheals
wheat114924572wheat
whee105429592whe_e
wheel115515342wheel
wheels123811722wheels
wheen115016052wheen
wheens124610612wheens
wheep136214352wheep
wheeps14439952wheeps
whelk154311062whelk
whelks16367322whelks
whelm134611982whelm
whelms14377572whelms
whelp136012092whelp
whelps14437842whelps
when105723042whe_n
whenas124610462whenas
where117019432where
wheres125917442wheres
whew137618782whe_w
whey135018712whe_y
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whips134917082whips
whirs115218092whirs
whist115322952whist
whists124613812whists
whit104834172whit_
white114920302white
whites123919882whites
whity145513472whity
whops135013932whops
whorts125111432whorts
whups134210002whups
whys137011662wh_ys
wilts85023502wilts
wists86728522wists
wites85536962wites
wits76044872w_its
woes76440662woe_s
wonts87621542wonts
worts88631182worts
wots76342892w_ots
wrens85016242wrens
wrest84925432wrest
wrests95313082wrests
writs86624382writs
wyes105727502wye_s
wytes114113432wytes

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.343520965.0
2DLD Change Limit538001711.50035866.7
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.88994595.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.