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 “khanates” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
khanates153573(None) 
khanate1437071khanate_
cyanates13238432cyanates
emanates10311332emanates
hamates122917682_hamates
karates115617472k_arates
kyanites15216682kyanites
phenates13611572phenates
phonates13410642phonates
thanages12107622thanages
thanatos1165122thanatos
abates85825033__abates
agates76121343__agates
agnates82813193_agnates
alates64833963__alates
annates72415423_annates
antes56334323__an_tes
apanages1137013apanages
aphanites1448263aphanites
canapes111213083_canapes
carates95630613_carates
chamades16138653chamades
chances145218093chan_ces
chancres15429363chancres
changes134517583chan_ges
chantages1546583chantages
chanted134015953chan_ted
chanter123919733chan_ter
chanters134016743chan_ters
chantey154112543chan_tey
chanteys16387493chan_teys
chanties132615803chanties
chants115020393chan_t_s
chapatis15127943chapatis
charades141310853charades
charases131312763charases
chayotes1636503chayotes
chelates132713843chelates
cholates132414763cholates
cognates11311583cognates
craniates11310653craniates
cyanate12259703cyanate_
cyanites132610163cyanites
dealates92716683dealates
donates83217223_donates
emanate9312473emanate_
emanated1139163emanated
enates64026433__enates
gahnites1235703gahnites
gradates10510783gradates
granites92116363granites
guanases936233guanases
halites103221193_halites
hamate113319833_hamate_
hanaper1237133_hanaper
hanapers1346963_hanapers
hances115621283_han_ces
handaxes1938403_handaxes
handles114020653_handles
hankies143617763_hankies
hanses95022633_han_ses
hanted104124313_han_ted
hantles104117513_hantles
hants86335403_han_t_s
hapaxes1936593_hapaxes
hastes95727073_ha_stes
hates86742573_h__ates
humates122813193_humates
imamates1237663imamates
kainites1238793kainites
kanakas10327213k_anakas
kanas95326913k_ana__s
kanes95529373k_an__es
kantars11310033k_antars
karate105320923k_arate_
karats106420493k_arat_s
kentes105118653k_en_tes
kernites1269113kernites
keynotes1543633keynotes
khalifates2042153khalifates
khans124615173khan___s
khats125316013kh__at_s
kinases113511123k_inases
knaves13439523k__naves
knawes13328393k__nawes
kyanises15206393kyanises
kyanite14237313kyanite_
kyanizes24205283kyanizes
lanate6421263_lanate_
lanated8313203_lanated
magnates11511613magnates
malates93522603_malates
manages103418963_manages
manatee9317663_manatee
manatees10310423_manatees
manats84623463_manat_s
mandates11314093_mandates
mantes84430783_man_tes
nates55238333___nates
neonates8310063neonates
odonates947743odonates
oxalates1557063oxalates
ozonates1745963ozonates
palates93624933_palates
penates93321603_penates
phenate12412193phenate_
phonate12411813phonate_
phonated1447893phonated
phorates13413043phorates
placates12311753placates
planate9314573planate_
pronates10418373pronates
qanats154112813_qanat_s
ruinates8311883ruinates
savates10312953_savates
senates73322613_senates
shandies122714103shandies
shannies113411253shannies
shantey134210043shan_tey
shanteys14395513shan_teys
shanties113116583shanties
shantis103313103shan_tis
stagnates1046733stagnates
tannates81911953tannates
thanage11117943thanage_
thanatoses1343543thanatoses
thanes94918983than__es
thenages12107483thenages
thionates12106663thionates
titanates976093titanates
uranites82514643uranites
urinates8314133urinates
vacates12312833_vacates
whangees15275063whangees

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621346.95321021.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.43524033.8
 
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.