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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
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
keef115830001keef
kef105639661k_ef
kief117128411kief
knee85323601knee
knew115912121knew
alef76340692alef
ane37866952ane_
anes45255932anes
anew76623132anew
beef96233682beef
chef125125622chef
clef97028182clef
def76546722_def
ef57345362__ef
enuf7323842enuf
fief107331362fief
ganef96322462ganef
gonef95221292gonef
kae76744542kae_
kaes85734062kaes
kaf106845512k_af
kaif116933932kaif
kane85133972kane_
kanes95529372kanes
kea76540912k_ea
keefs125116282keefs
keek75624972keek
keel85729472keel
keen84830412keen
keep106329822keep
keet85347342keet
kefs115922742k_efs
keg86432542k_eg
ken76343982k_en
kenaf12316032kenaf
keno87926432keno
kens85435232kens
kent86846962kent
kep96437202k_ep
kerf115827462kerf
kex146029582k_ex
key105833332k_ey
khaf145319602khaf
khet116328622khet
kiefs126112202kiefs
kier86526812kier
kif105941192k_if
kine85643432kine_
kines95039132kines
knap105815402knap
knar85818722knar
knead10429662knead
kneed104612052kneed
kneel95012032kneel
knees95114872knees
knell94210922knell
knelt94617682knelt
knife1210010132knife
knit85728142knit
knob107417012knob
knop107116592knop
knot85630502knot
know116115842know
knur85311972knur
koel84519942koel
kue76631862kue_
kues86426772kues
kune85424572kune_
kye107327272kye_
kyes115124932kyes
lief76036992lief
ne27045102_ne_
neb57238622_neb
nee36657782_nee
neg47237342_neg
neif75429492_neif
net36670292_net
new66237092_new
one37050912one_
ones46146532ones
reef74938212reef
ref66053292_ref
sned56026052sned
tref77030992tref

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 Filter178691298720.263679433.5
2DLD Change Limit29872840.84335435.3
3Display Results84840.0165250.0
 (SQL Overall)178691841.122159261.1
 
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.