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

125 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
knees9511487(None) 
knee85323601knee_
kneed104612051kneed
kneel95012031kneel
kneels10408931kneels
akees96119242akees
akenes104817342akenes
aneles64626292aneles
anes45255932an_es
antes56334322antes
bees65453382_bees
benes75536232benes
brees75632552brees
cees65941592_cees
dees56356632_dees
denes65639722denes
donees74519492donees
drees65628522drees
epees75219832epees
fees76450602_fees
flees85828752flees
frees86131392frees
gees55647882_gees
genes65133092genes
ghees95215552ghees
glees65027592glees
grees65132472grees
jees115938542_jees
kaes85734062k_aes
kales95730982kales
kames115024692kames
kanes95529372kanes
keas86337092k_eas
keef115829992k_eef
keefs125116282keefs
keek75624962k_eek
keeks84717252keeks
keel85729462k_eel
keels94622412keels
keen84830402k_een
keens95721182keens
keep106329812k_eep
keeps116020282keeps
keet85347332k_eet
keets95123482keets
keeves133711982keeves
kefs115922742k_efs
kegs95824012k_egs
kenos95220622kenos
kens85435232k_ens
kentes105118642kentes
keps106027302k_eps
kexes166216812kexes
keys116322162k_eys
khets124913432khets
kibes115521112kibes
kiefs126112202kiefs
kiers95320092kiers
kikes85122552kikes
kines95039132kines
kineses113111252kineses
kites95432542kites
knaps115511172knaps
knars94416112knars
knaves13439522knaves
knawes13328392knawes
knead10429662knead
kneads11357092kneads
knell94210922knell
knells10439252knells
knelt94617682knelt
knew115912122kn_ew
knifes136210212knifes
knits93914742knits
knives13458552knives
knobs11519712knobs
knops115911812knops
knots95614722knots
knows124912412knows
knurs94511152knurs
koels94613902koels
kreep114610412kreep
kreeps12427412kreeps
krewes1337922krewes
kues86426772k_ues
kyes115124932k_yes
kytes125012912kytes
lees45455882_lees
lenes54738522lenes
nebs66124982_nebs
nee36657782_nee_
need54934152_need
needs65719632_needs
neem67328082_neem
neems77316292_neems
neep65728312_neep
neeps75617882_neeps
negs55727362_negs
nenes55329672_nenes
ness45526562_ness
nets45941532_nets
neves87021872_neves
news76127372_news
noes45845392_noes
ogees65119142ogees
ones46146532on_es
pees65257372_pees
penes75839222penes
prees75937172prees
ranees64623962ranees
rees45364192_rees
sees45361052_sees
skees95023122skees
skenes104616632skenes
sneds65715352sneds
sneer54919952sneer
sneers64016172sneers
sneesh945892sneesh
snyes85012752snyes
tees45353582_tees
trees55835762trees
tyees86019452tyees
vees75439432_vees
wees76249122_wees
zees136331892_zees

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.1231452772.4
2DLD Change Limit538001251.73331044.4
3Display Results1251250.0333787.9
 (SQL Overall)1786911251.88994595.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.