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

147 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
liveried123873(None) 
livered113111631liver_ed
liveries11314371liveries
diverged14256882diverged
diverted13199582diverted
levered114212302lever_ed
livelier1136872livelier
livened11238932live_ned
livering122012382livering
liverish1447862liverish
riverbed14245142riverbed
slivered12218102sliver_ed
adverted1336103adverted
aeried74221863__aeried
averred11237593_averred
averted112211613_averted
caverned1436163caverned
chivaried1844053chivaried
clavered14187633claver_ed
clovered14187363clover_ed
covaried1448003covaried
covered133315293cover_ed
delivered1445033deliver_ed
deliveries1446013deliveries
dimerized2246233dimerized
diverge12347643diverge_
diverges13258313diverges
diverse11429993diverse_
diverter12238623diverter
divested13268213divested
divorced1544313divorced
divvied1544813div_vied
everted112711853_everted
fevered14339723fever_ed
fibered1337643fiber_ed
fiberized2444533fiberized
fierier103511193fi_erier
fineries112416743fineries
governed1335193governed
havered144011453haver_ed
hovered143411573hover_ed
inversed12269283inversed
inverted122312163inverted
ivied94710523_iv__ied
ivories10310713_ivories
lagered92311153lager_ed
laterized1979903laterized
laveered1235253laveered
layered11259413layer_ed
leered73816223l_eer_ed
leerier73111503l_eerier
leveed104111373leve__ed
leveled114010383leve_led
levelled12327443levelled
leveraged1463783leveraged
leveret103014003lever_et
levering122212503levering
levied104111433l__evied
libeled10249413libe_led
libelled11317213libelled
liberated1299473liberated
liberties1149203liberties
licenced13145773licenced
licensed11145723licensed
lierne638023li_erne_
liernes739623li_ernes
likelier1235283likelier
likened12267353like_ned
lilied73913213li__lied
limbered13158123limber_ed
limerick1645403limerick
linearised1143933linearised
linearized2044583linearized
lineated9711063lineated
linebred1144963linebred
lingered10129643linger_ed
lingerie959203lingerie_
lingeries10511813lingeries
lippered13287953lipper_ed
liquefied2242493liquefied
littered92511383litter_ed
lived95523723liv___ed
liveliest1247093liveliest
livelily1444103livelily
livener10278943live_ner
livening12248153livening
liver85132963liver___
liverleaf1542103liverleaf
livers94927823liver__s
livery124910903liver__y
liverymen1742813liverymen
livid96714423liv__i_d
livier97514593liv__ier
livre85613253liv_r_e_
livres94311863liv_r_es
loitered938183loiter_ed
louvered1244993louver_ed
lovebird1442643lovebird
lovelier1136433lovelier
lovelies1139893lovelies
lowered112711913lower_ed
miseries10320403miseries
mitered103213233miter_ed
niterie7313743niterie_
niteries8318383niteries
obverted1435103obverted
overbed132811853_overbed
overed102216623_over_ed
overfed142510253_overfed
pierced12347593pi_erced
pineries102419083pineries
queried1738683_queried
quivered2144823quiver_ed
reverbed14269223reverbed
revered112819333rever_ed
reverie103615163reverie_
reveries112518513reveries
reversed122711613reversed
reverted122714713reverted
riverbeds15243073riverbeds
riverhead1642993riverhead
riverine11310803riverine
riverside1344913riverside
riverweed1643053riverweed
riveted11258573rive_ted
rivetted12226093rivetted
severed113513863sever_ed
shivered15177103shiver_ed
silvered12237563silver_ed
slavered12188033slaver_ed
slaveries1249683slaveries
sliverer11237633sliver_er
slivering1338083slivering
tierced10347053ti_erced
tiered73613973ti_er_ed
unvaried1239683unvaried
unversed122310433unversed
varied104817863__varied
verged114815153__verged
verier94620963__verier
versed104515513__versed
vineries112716043vineries
vivaries1439263vivaries
viverrid1543013viverrid
vivified1845893vivified
wavered142910433waver_ed
wineries112316533wineries

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.1561145455.1
2DLD Change Limit1461621476.86021306.4
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.07625253.1
 
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.