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

113 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
level8411655(None) 
bevel104517041bevel
devel94217121devel
kevel124213091kevel
levee84023811levee
levels94113281levels
lever85125161lever
revel84423161revel
bedel84219392bedel
betel74419902betel
bevels113913982bevels
bezel165215172bezel
bilevel1244392bilevel
clever114611532clever
devels104313902devels
devil94714732devil
eel37946842_e_el
eleven988302eleven
elver85216242elver
elves85118742elves
eve66331162_eve_
even75222272_even
ever77027692_ever
eves76230462_eves
evil75318072_evil
feel75233842fe_el
fever115617952fever
gavel95815182gavel
heel75034222he_el
hovel115017682hovel
jebel145612142jebel
jewel156711702jewel
keel85729462ke_el
kevels134410712kevels
kevil12399862kevil
label75019382label
lapel73716682lapel
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
leal46043272le_al
leave84723722leave_
leaved105719022leaved
leaven95013072leaven
leaver94321512leaver
leaves94222382leaves
leben7314852leben
lee36068142le_e_
leek85331732le_ek
leer46239352le_er
lees45455882le_es
leet45957902le_et
legal65715942legal
leger65721502leger
leges64427282leges
leke85527402leke_
lenes54738522lenes
leper74820742leper
leses54930812leses
lev66139422lev__
leva77020712lev_a
leveed104111372leveed
levees93714522levees
leveled114010382leveled
leveler10399902leveler
levelly1335842levelly
levers94621322levers
levied104111432levied
levier94013872levier
levies93919862levies
levin84816412levin
levis85818552levis
levo76820062lev_o
levy106418502lev_y
lexes127225262lexes
libel74116102libel
lieve86315472lieve_
liever94611862liever
live76540992live_
lived95523722lived
lively123310812lively
liven85021732liven
liver85132962liver
lives86133192lives
losel54419422losel
love75234762love_
loved95021362loved
lovely12339712lovely
lover85526452lover
loves85332012loves
navel87016572navel
neve76224832neve_
never86218642never
neves87021872neves
newel86114132newel
novel85615992novel
peel65535612pe_el
ravel84621512ravel
rebel73421292rebel
reel45240532re_el
refel84920812refel
repel74921402repel
reveal94115052reveal
revels94220572revels
revet84938842revet
seel45042982se_el
seven84118312seven
sever85426052sever
teel46335802te_el
unlevel1035912unlevel
wedel94513952wedel
weel75834082we_el

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.0931921408.6
2DLD Change Limit538001131.68631909.8
3Display Results1131130.0333424.2
 (SQL Overall)1786911131.81298615.3
 
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.