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

156 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
liberate10111338(None) 
liberated1299471liberated
liberates111012941liberates
librate93214231lib_rate
literate81216891literate
aliterate91611342aliterate
berate84729022__berate
deliberate1347122deliberate
hibernate1444992hibernate
iterate71119112_iterate
lacerate102214712lacerate
liberal9310192libera_l
liberals1039412liberals
liberator1147062liberator
liberty1237162liber_ty
librae84310172lib_ra_e
librated113110312lib_rated
librates103412952lib_rates
lineate7815152line_ate
literates91415652literates
literati81210802literati
vibrate122811522vib_rate
acerate92818913_acerate
acierate10311813acierate
aerate64830553__aerate
alienate8311553ali_enate
aliterates101510763aliterates
alliterate1086633alliterate
ameerate1039633ameerate
asperate10312373asperate
berake124216083__berake
berated104422133__berated
berates94126873__berates
biforate1346903biforate
biseriate1147673biseriate
biserrate1145783biserrate
borate85026153__borate
calibrate1347743calib_rate
cerate84829463__cerate
cirrate92413493ci_rrate
citrate92216803ci_trate
cybernate1643603cybernate
deaerate9314173deaerate
deliberated1545633deliberated
deliberates1446793deliberates
derate74531233__derate
digerati1047403digerati
disrate81418523di_srate
elaborate1146883elaborate
emeerate10410103emeerate
exuberate1845623exuberate
federate12310883federate
fiberize2246143fiberize
figurate1237193figurate
filtrate1148223filtrate
generate9312903generate
glabrate1146043glab_rate
glomerate1245673glomerate
hebetate1347053hebetate
hibernated1643223hibernated
hibernates1544623hibernates
ideate7313683_ide_ate
illiterate10125893illiterate
ingrate8715123_ingrate
irate55627983_i__rate
iterated91213823_iterated
iterates81317823_iterates
itinerate9116253itinerate
labellate11126923labellate
labiate91313573lab_iate
laborite10410703laborite
lacerated122210683lacerated
lacerates112413783lacerates
laterite8716343laterite
laureate888023laureate
layerage1244963layerage
legate72917453l__egate
leverage1285393leverage
levirate1147623levirate
libelant1048563libelant
libelants1145303libelants
libelee92510983libe_lee
libellee10227733libellee
liber74723623liber___
liberalise1247593liberalise
liberality1545903liberality
liberalize2146953liberalize
liberally1446263liberally
liberating1349253liberating
liberation1269993liberation
liberators1247013liberators
libers84721443liber__s
liberties1149203liberties
libertine1147433libertine
libra74712423lib_ra__
library1245323lib_rary
libras83711703lib_ra_s
libretti1043583libretti
libretto1043703libretto
licente91210893lice_nte
lierne638023li_er_ne
lifecare1364113lifecare
liftgate1243413liftgate
ligate72519253li__gate
ligulate92510253ligulate
limbate1139213li_mbate
limeade1076123lime_ade
limewater1444073limewater
lineage878983line_age
lineated9711063line_ated
lineolate946283lineolate
liquate1638423li_quate
lisente71210703lise_nte
literacy1346803literacy
literal7613273litera_l
literals8312293literals
literary1147753literary
literately1345303literately
literatim11127183literatim
literator948683literator
literature1094193literature
literatus9146823literatus
litigate948303litigate
littermate1243193littermate
lobate82915243lob__ate
lobulate1078833lobulate
lustrate8310443lustrate
lyrate94112103l__yrate
macerate122314073macerate
migrate101314173mi_grate
misrate91319143mi_srate
moderate11710993moderate
nitrate72017013ni_trate
numerate101610393numerate
obliterate1245073obliterate
operate9615733_operate
overate10620963_overate
picrate112014143pi_crate
pileate93815923pile_ate
pirate82322883pi__rate
reiterate9412933reiterate
sibilate1049533sibilate
siderite9411363siderite
titrate72215573ti_trate
tolerate8312323tolerate
ulcerate1039733ulcerate
underate9918603underate
unliberated1444253unliberated
valerate11311473valerate
venerate11312903venerate
vibrated14228393vib_rated
vibrates132210613vib_rates
vibrato12247383vib_rato
vicarate1378603vicarate
vizierate2143663vizierate
vizirate2045353vizirate

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621566.93621073.0
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.46923924.4
 
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.