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

131 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
knee8532360(None) 
kneed104612051kneed
kneel95012031kneel
knees95114871knees
knew115912121knew
nee36657781_nee
agee56241492agee
ajee115928232ajee
akee85936812akee
akene95818662akene
alee46652322alee
ane37866952an_e
anele55628832anele
anes45255932anes
anew76623132anew
ante46538902ante
awee76336642awee
bee56262402_bee
bene66439492bene
bree67241262bree
cee55952702_cee
dee47665822_dee
dene56643412dene
donee66931012donee
dree56638322dree
epee64628502epee
fee66862012_fee
flee76238792flee
free75940182free
gee45359202_gee
gene56237222gene
ghee85726112ghee
glee55239062glee
gree56641562gree
jee106648642_jee
kae76744542k_ae
kaes85734062kaes
kale86533752kale
kame105728232kame
kane85133972kane
kanes95529372kanes
kea76540912k_ea
keef115830002keef
keek75624972keek
keel85729472keel
keen84830412keen
keep106329822keep
keet85347342keet
keeve124512132keeve
kef105639662k_ef
keg86432542k_eg
ken76343982k_en
keno87926432keno
kens85435232kens
kent86846962kent
kente95821072kente
kep96437202k_ep
kex146029582k_ex
key105833332k_ey
khet116328622khet
kibe106523452kibe
kief117128412kief
kier86526812kier
kike76524792kike
kine85643432kine
kines95039132kines
kite85338242kite
knap105815402knap
knar85818722knar
knave12389462knave
knawe12397882knawe
knead10429662knead
kneels10408932kneels
knell94210922knell
knelt94617682knelt
knife1210010132knife
knit85728142knit
knob107417012knob
knop107116592knop
knot85630502knot
know116115842know
knur85311972knur
koel84519942koel
kore85834162kore
kreep114610412kreep
krewe1238192krewe
kue76631862k_ue
kues86426772kues
kune85424572kune
kye107327272k_ye
kyes115124932kyes
kyte117017762kyte
lee36068142_lee
nae35952742_nae
ne27045102_n_e
neb57238622_neb
need54934152_need
neem67328082_neem
neep65728312_neep
neg47237342_neg
nene45932062_nene
net36670292_net
neve76224832_neve
new66237092_new
ogee57629882ogee
once65423082once
one37050912on_e
ones46146532ones
pee56066512_pee
pree67044732pree
ranee55438102ranee
ree37974072_ree
see35772262_see
sene46848052sene
skee85431472skee
skene96118122skene
sned56026052sned
sneer54919952sneer
snye77115492snye
tee38366872_tee
thee78039062thee
tree47745812tree
twee76827082twee
tyee75131422tyee
unbe65319272unbe
unde55825482unde
undee65327272undee
vee65750182_vee
wee66760812_wee
whee105429592whee
zee126143232_zee

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.283631417.0
2DLD Change Limit298721310.73340753.1
3Display Results1311310.0333969.7
 (SQL Overall)1786911311.049170344.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.