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

98 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
levee8402381(None) 
leveed104111371leveed
levees93714521levees
level84116551level
lever85125161lever
bevel104517042bevel
clever114611532clever
cuvee10316142cuvee
devel94217122devel
eleven988302eleven
elver85216242elver
elves85118742elves
epee64628502_epee
eve66331162_ev_e
even75222272_even
ever77027692_ever
eves76230462_eves
fever115617952fever
gelee63626982gelee
keeve124512122keeve
kevel124213092kevel
laree56036292laree
lave75642142lav_e
laved95028592laved
laveer94110422laveer
laver85031792laver
laves86039152laves
lease55230262lease
leave84723722leave
leaved105719022leaved
leaven95013072leaven
leaver94321512leaver
leaves94222382leaves
leben7314852leben
ledge76519462ledge
lee36068142l__ee
leek85331732le_ek
leer46239352le_er
lees45455882le_es
leet45957902le_et
leger65721502leger
leges64427282leges
leke85527402le_ke
lenes54738522lenes
lense54523432lense
leone55018822leone
leper74820742leper
leses54930812leses
lessee64116362lessee
lethe85717302lethe
lev66139422lev__
leva77020712lev_a
leveled114010382leveled
leveler10399902leveler
levels94113282levels
levered114212302levered
leveret103014002leveret
levers94621322levers
levied104111432levied
levier94013872levier
levies93919862levies
levin84816412levin
levis85818552levis
levo76820062lev_o
levy106418502lev_y
lexeme1536492lexeme
lexes127225262lexes
lieve86315472liev_e
liever94611862liever
live76540992liv_e
lived95523722lived
liven85021732liven
liver85132962liver
lives86133192lives
livre85613252livre
love75234762lov_e
loved95021362loved
lover85526452lover
loves85332012loves
lycee104716742lycee
melee73729102melee
neve76224832nev_e
never86218642never
neves87021872neves
peeve104915252peeve
pewee10319972pewee
reeve84121322reeve
resee54336332resee
revel84423162revel
revere94621252revere
revet84938842revet
revue81114452revue
seven84118312seven
sever85426052sever
severe94016082severe
sleeve93411592sleeve
tepee74724212tepee
vee65750182__vee

Search took 3 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.0802233637.5
2DLD Change Limit53800981.90328271.2
3Display Results98980.0166125.0
 (SQL Overall)178691981.99989390.2
 
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.