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

128 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
khets12491343(None) 
hets75547201_hets
keets95123481keets
khats125316011khats
khet116328621khet_
kheth15509751kheth
kheths16495971kheths
whets115019611whets
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
kaes85734062kae_s
karts97630112karts
kats85944332k_ats
keas86337092k_eas
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keet85347342keet_
kefs115922742k_efs
kegs95824022k_egs
kelts95222632kelts
kens85435232k_ens
keps106027302k_eps
keto86223452k_eto
keys116322162k_eys
khafs15648842khafs
khans124615172khans
khat116730722khat_
kheda1346532kheda
khedas1446312khedas
khis117017982kh_is
kiefs126112202kiefs
kiers95320092kiers
kilts95122182kilts
kists95822112kists
kites95432542kites
kits86441772k_its
knees95114872knees
knits93914742knits
knots95614722knots
koels94613902koels
kues86426772kue_s
kyats125012442kyats
kyes115124932kye_s
kytes125012912kytes
leets54927122leets
lets47147942_lets
meets74224612meets
nets45941532_nets
pets66248332_pets
phots105418502phots
phuts104613502phuts
poets76024442poets
rets45352562_rets
rheas84816952rheas
sets45549502_sets
sheas86331792sheas
sheds96122702sheds
sheets93918502sheets
shes75734352she_s
shews115924712shews
shits84731172shits
shots84730852shots
shuts85622482shuts
skeets104513252skeets
stets55423912stets
suets55126102suets
tets45847462_tets
thefts12387922thefts
thens85921832thens
theta83414572theta
thetas93011572thetas
thews117416192thews
trets55928022trets
vets76835092_vets
weets85427722weets
wets75940292_wets
whats117718992whats
wheats125013222wheats
whens114618762whens
whet105133782whet_
whews145114492whews
wheys145911552wheys
whits115923822whits

Search took 7 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.703254183.5
2DLD Change Limit538001286.0468898.4
3Display Results1281280.1101163.6
 (SQL Overall)1786911286.85926052.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.