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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
chant105932691chant
hant75461591_hant
khan115819141khan_
khans124615171khans
khat116730721kha_t
alant55742292alant
ant37270792__ant
avant86224662avant
bhang115512922bhang
brant74742172brant
cant66362032_cant
chang115418562chang
chants115020392chants
chanty145215822chanty
chapt125827642chapt
chart105038282chart
chat95546132cha_t
chaunt11613492chaunt
ghast95621222ghast
ghat86435282gha_t
ghaut95919432ghaut
giant65430592giant
grant64840022grant
haet75659502_haet
haft105941842_haft
haint85436322_haint
halt76056302_halt
hand86833712_hand
hang85535552_hang
hank115134142_hank
hants86335402_hants
hart76865772_hart
hast76259482_hast
hat67289962_ha_t
haunt85229132_haunt
haut75949732_haut
hent76656382_hent
hint77455742_hint
hunt76445492_hunt
kana85928532k_ana
kane85133972k_ane
kart86750802k_art
kat77468292k_a_t
kent86846962k_ent
khadi1367602khadi
khaf145319602kha_f
khafs15648842khafs
khaki1157642khaki
khanate1437072khanate
khaph17395962khaph
khats125316012khats
khet116328622kh_et
kiang104811352kiang
koan85425032koan_
koans95818622koans
kraft125721012kraft
krait94726772krait
kraut95221402kraut
kyat116025522kya_t
leant56737782leant
meant76537212meant
pant66061262_pant
phat95837862pha_t
plant75437112plant
quant143624812quant
rant45864682_rant
riant55833152riant
scant79735072scant
shaft115725272shaft
shalt85534492shalt
shank125422192shank
shanti94014092shanti
shanty124715122shanty
shat76456602sha_t
shent85933502shent
shunt85226512shunt
slant55238702slant
than76128772than_
thane86122532thane
thank125817802thank
that75639322tha_t
want76156172_want
whang124813382whang
what105434072wha_t

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.313570897.8
2DLD Change Limit53800841.34340059.6
3Display Results84840.0165250.0
 (SQL Overall)178691841.672106872.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.