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

159 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
lanceted113707(None) 
blanketed1643912blanketed
canceled13279402canceled
cancered132411552cancered
faceted13509562fa_ceted
lanated8313202lan_ated
lanced93717722lanc__ed
lancelet1049472lancelet
lancet84223572lancet__
lancets93411162lancet_s
lappeted13255832lappeted
acceded1336103_acceded
accented13107773_accented
accepted15105383_accepted
accreted1336333_accreted
acted88521733_a_c_ted
aneled74719283_an_eled
angeled93211513_angeled
angered93013473_angered
annexed1535753_annexed
ansated84214003_ansated
anted66328243_an__ted
anteed75616113_ante_ed
baccated15148373baccated
bannered11299323bannered
banqueted2143543banqueted
bantered113313633bantered
basseted1136743basseted
blanched16308603blanc_hed
bonneted1136223bonneted
cacheted16148233cacheted
canceler12238913canceler
cancelled1456743cancelled
cankered153010223cankered
canted94825783can__ted
cantered113415983cantered
carpeted1338953carpeted
casketed1534953casketed
conceded1438293conceded
conceited14310423conceited
concerted14312113concerted
concreted1439413concreted
danced105315253danc__ed
dandered112110963dandered
dangered11248513dangered
enacted10310643enac_ted
facete115014833fa_cete_
facetted1445743fa_cetted
falcated1438473falcated
fancied133310603fanc_ied
flanneled1343313flanneled
galleted1038213galleted
gandered112211173gandered
gantleted1144393gantleted
garreted1057523garreted
glaceed1136193gla_ce_ed
glanced11439233glanc__ed
glandered1236333glandered
hankered16289443hankered
hanseled1237713hanseled
hanted104124313han__ted
incented112412543_incented
incepted13177773_incepted
incited103314623_incited
jacketed22146533jacketed
junketed2033523junketed
laagered1055853laagered
labeled102510563la_beled
labiated11109303labiated
laced87132643la_c__ed
lacerated122210673la_cerated
lacertid1146383la_certid
lacked135324653la_c_ked
lackered15108673lackered
lackeyed18104513lackeyed
lactated1138863lactated
laddered1136743laddered
ladened979053la_dened
lagered92311153la_gered
laicised1145643laicised
laicized2046043laicized
lakebed1434783la_kebed
lamented1138193lamented
lanate6421263lan_ate_
lance75126723lanc__e_
lancelets1144833lancelets
lancer84319973lanc__er
lancers93616643lance_rs
lances84824103lanc__es
lancewood1552793lancewood
lancinated1345573lancinated
landed84619243lan__ded
lanneret82512363lanneret
lapeled10258893la_peled
lappered13288213lappered
larcener1036493larcener
lariated91212063lariated
lasted74323603la__sted
latched133914063latc_hed
lated65240673la___ted
latened8711923la_tened
lathered121512323lathered
launched1475403launc_hed
laundered1185023laundered
laureated1096153laureated
laureled934543laureled
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
leafleted1342893leafleted
lenited8812433len_ited
lichted13268803l_ichted
lineated9711063lineated
lingered10129643lingered
linseed838203linse_ed
linted74021823lin__ted
located103114183l_ocated
lunated8310823lun_ated
lunched133911823lunc_hed
lunted74517523lun__ted
lynched16376753lync_hed
mandated12310293mandated
mannered11249653mannered
marketed1537323marketed
packeted17148283packeted
palleted1139873palleted
pancaked1734893pancaked
pancetta1244653pancetta
pandered121812573pandered
paneled10612573pan_eled
panted95024823pan__ted
parceled1338343parceled
pargeted1238683pargeted
placated1338453pla_cated
planted103516123plan__ted
rabbeted1334443rabbeted
racemed1237013ra_cemed
racheted14149503racheted
racketed15169123racketed
ranched133113603ranc_hed
rancored1137223rancored
ranted74324703ran__ted
ratcheted1554783ratcheted
sacheted14127833sacheted
slandered1137473slandered
slanted83514743slan__ted
sonneted936183sonneted
spanceled1443693spanceled
tableted1137533tableted
targeted1037483targeted
tincted1037273tinc_ted
unacted10312733unac_ted
unceded11410563_unceded
vacated1349353va_cated
valeted1139013va_leted
wandered132110793wandered
wanted104319723wan__ted
wauchted1753373wauchted
yachted1634853ya_chted

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.406440125.6
2DLD Change Limit1461621597.28020077.2
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.74923059.9
 
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.