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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
libelee9251098(None) 
libeled10249411libeled
libelees10227211libelees
libeler9219001libeler
libellee10227731libellee
labeled102510562labeled
labeler92310182labeler
libel74116102libel__
libelers10238622libelers
libelled11317212libelled
libellees11274982libellees
libeller10297432libeller
libels85112692libel_s
abele76323253_abel_e
abeles84719393_abeles
alible8311973alib_l_e
alienee71013153ali_enee
belie75630383__belie
belle75827833__belle
bibelot1167343bibelot
bible95119423bib_l_e
bibles104617643bib_les
dibble114013843dibbl_e
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
fibered1337643fibered
fibulae12237013fibulae
gabelle10259213gabelle
gelee63626983__gelee
giblet93418893gib_let
ibexes15436163_ibexes
jubilee16298293jubilee
kibble143910953kibbl_e
kibbled16367983kibbled
kibbles153510253kibbles
label75019383label__
labelers10249413labelers
labella988943labella
labelled11278293labelled
labeller10248073labeller
labels84515683label_s
labile8315223labil_e
lapeled10258893lapeled
levee84023813l__evee
leveled114010383leveled
leveler10399903leveler
liable81415813liabl_e
libber104414013lib_ber
libelant1048563libelant
libeling1139873libeling
libelist10310823libelist
libellers11236033libellers
libelous1047193libelous
liber74723623lib__er
liberal9310193liberal
liberate101113383liberate
libers84721443libe_rs
liberty1237163liberty
liblab1035083lib_lab
librae84310173lib_rae
librate93214233librate
licence11119363licence
licencee12116463licencee
license9148423license
licensee10166303licensee
licente91210893licente
lichee114017973li_chee
lieder74912323li_eder
liefer9529573li_efer
liege65314433li_e_ge
lieges74113443li_eges
lierne638023li_erne
lieve86315473li_e_ve
liever94611863li_ever
lifeless11228143lifeless
lifelike15166223lifelike
lifeline11167663lifeline
ligulae8308753ligulae
ligule74010833ligul_e
ligules82210923ligules
likelier1235283likelier
likely13328133likel_y
likened12267353likened
limbered13158123limbered
limberer12187053limberer
limeade1076123limeade
limeless10249663limeless
lineage878983lineage
lineate7815153lineate
lineless82711943lineless
linelike12159003linelike
linemen938633linemen
lisente71210703lisente
lisle53916723li_sl_e
lisles63416283li_sles
listee64223063li_stee
little63312163littl_e
littler7348553littler
littles73212783littles
livelier1136873livelier
lively123310813livel_y
livened11238933livened
livener10278943livener
livered113111633livered
lobelia947213lobelia
lobeline1039963lobeline
lobule82910063lobul_e
lobules92510813lobules
melee73729103__melee
micelle1178343micelle
nibble103713283nibbl_e
nibbled12389073nibbled
nibbler11379273nibbler
nibbles114011693nibbles
riblet84222443rib_let
umbeled12208193umbeled
zibeline1946363zibeline

Search took 8 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271187.22018563.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.41924085.6
 
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.