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

143 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
livelier113687(None) 
likelier1235281likelier
lovelier1136431lovelier
lavalier1146042lavalier
leveler10399902level_er
leveller11317602leveller
libeler9219002libel_er
libeller10297432libeller
liveliest1247092liveliest
livelily1444102livelily
livener10278942live_ner
liveried1238732liveried
liveries11314372liveries
livier97514592liv__ier
lonelier838002lonelier
lovelies1139892lovelies
timelier1036712timelier
wifelier1434852wifelier
wiselier1137362wiselier
atelier7311623_atelier
belier84423563__belier
beveler124010693bevel_er
beveller13387693beveller
cavalier1348183cavalier
cicelies1269753cicelies
civilizer23104323civilizer
comelier12310653comelier
dimplier1336673dimplier
diverter12238623diverter
divulger1342553divulger
driveler1284693drivel_er
driveller1353853driveller
eelier64216463__eelier
fielder11217413fi_elder
fierier103511193fi_erier
gaselier946963gaselier
gigglier1154323gigglier
girlier8289523gi_rlier
hillier103413963hi_llier
homelier1338983homelier
hotelier1137633hotelier
inlier63615363_i_nlier
jigglier1754093jigglier
jinglier1655233jinglier
jivier16438613jiv__ier
kindlier1345763kindlier
kinglier1345633kinglier
labeler92310183label_er
labeller10248073labeller
lavaliere1252623lavaliere
lavaliers1254283lavaliers
laveer94110423lave__er
lavender1235143lavender
leerier73111503l_eerier
leveled114010383level_ed
levelers11259323level_ers
leveling122910433leveling
levelled12327453levelled
levellers12286053levellers
levier94013873l__evier
libeled10249413libel_ed
libelee92510983libel_ee
libelees10227213libelees
libelers10238623libel_ers
libeling1139873libeling
libelist10310823libelist
libelled11317213libelled
libellee10227733libellee
libellers11236033libellers
licencer12146133licencer
licenser10155883licenser
lieder74912323li_e_der
liefer9529573li_e_fer
liever94611863li_e_ver
lifelike15166223lifelike
lifeline11167663lifeline
lifelines12147053lifelines
likeliest1346123likeliest
lilied73913213li__lied
lilies63021413li__lies
limbier11349113li_mbier
limier83518723li__mier
limpsier1234433limpsier
linelike12159003linelike
lingier84113383li_ngier
linier64423793li__nier
lintier73613803li_ntier
lippier112710573li_ppier
liquefier2142303liquefier
littler7348553littl_er
liveliness1345633liveliness
livelong1243403livelong
lively123310813livel__y
livened11238933live_ned
liveners11217933live_ners
livening12248153livening
liver85132963liv___er
livered113111633live_red
livering122012383livering
liverish1447863liverish
liviers104211073liv__iers
livyer12426293liv__yer
lordlier935363lordlier
loudlier934953loudlier
loveliest1246973loveliest
lovelily1444333lovelily
lowlier10338903l_owlier
millier93716703mi_llier
nigglier1044843nigglier
novelizer2144703novelizer
oilier64417233oi__lier
pimplier1445413pimplier
raveler104212463ravel_er
raveller11339263raveller
relier65826183__relier
reveler104116343revel_er
reveller112912193reveller
ripplier1234463ripplier
riveter10208753rive_ter
sicklier1457213sicklier
sideliner10126013sideliner
sillier74017593si_llier
sliverer11237633slive_rer
slovenlier1351643slovenlier
sniveler1155253snivel_er
sniveller1253703sniveller
steelier839193steelier
svelter10359673_svelter
tinglier956403tinglier
tinklier1255443tinklier
unlikelier1451933unlikelier
unlovelier1352153unlovelier
vealier102712173__vealier
veiler93814353__veiler
veliger1137313__veliger
verier94620963__verier
viewier1334983vi_ewier
vivifier1745173vivifier
wielder11197673wi_elder
wieldier1234283wi_eldier
wigglier1354453wigglier
wilier93217073wi__lier
yielder11175113yi_elder

Search took 7 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.423422437.4
2DLD Change Limit1461621436.31023163.5
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.79626293.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.