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 “targeted” 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
targeted103748(None) 
pargeted1238671pargeted
carpeted1338942carpeted
garreted1057522garreted
gorgeted1135352gorgeted
margented1346812margented
marketed1537322marketed
pargetted1345662pargetted
retargeted1243842retargeted
tableted1137532tableted
target75028902target__
targets84314222target_s
tarted74923372tar__ted
tarweed1137342tarwe_ed
turreted935372turreted
agented939423_a_gented
agreed84712503_agre_ed
angeled93211503_angeled
angered93013473_angered
arete56031353_ar_ete_
aretes64425353_ar_etes
argled85314553_arg_led
argued84311173_arg_ued
arrested939153_arrested
badgered1336213badgered
barbered13259543barbered
barged105822643barg__ed
bargee94624443barge_e_
bargees105415873barge_es
bargemen1346403bargemen
barreled1137843barreled
bartered113113013bartered
basseted1136743basseted
budgeted1344883budgeted
cacheted16148233cacheted
careened1139193careened
careered1139493careered
carted98631443car__ted
casketed1534953casketed
corseted11311473corseted
curveted1435293curveted
daggered12246403daggered
dangered11248513dangered
darkened1435943darkened
darted84620923dar__ted
faceted13509563fa_ceted
faggoted1443103faggoted
fagoted1236073fa_goted
farted105121783far__ted
ferreted1236323ferreted
fidgeted1443893fidgeted
galleted1038213galleted
gardened1137003gardened
garget84327273garget__
gargets94614573garget_s
gargety12388043garget_y
gargled104210673garg_led
garmented1345883garmented
garnered10247113garnered
garoted9710133gar_oted
garotted1066193garotted
garroted1056783garroted
gartered10319583gartered
greeted93111383_greeted
hardened1338613hardened
harkened1637483harkened
harvested1644093harvested
jacketed22146533jacketed
jargoned1735233jargoned
laagered1055853laagered
lagered92311153la_gered
lanceted1137073lanceted
lappeted13255833lappeted
lariated91212063lariated
margined1237743margined
marketer1437383marketer
marted94425213mar__ted
marveled1436433marveled
narrated9310323narrated
packeted17148283packeted
palleted1139863palleted
parapeted1446473parapeted
parceled1338333parceled
parented11912213parented
parged104922043parg__ed
parget94529393parget__
pargets105215193parget_s
parietes10714543parietes
parleyed1436233parleyed
parqueted2144213parqueted
parroted1158843parroted
parted94228683par__ted
rabbeted1334443rabbeted
racheted14149503racheted
racketed15169123racketed
sacheted14127833sacheted
saggered11237553saggered
staggered1244473staggered
stargazed2043073stargazed
started84217323star__ted
tabered103311593ta_bered
tabletted1244833tabletted
tagged93418123ta_g_ged
tailgated1145133tailgated
tainted83512423ta_inted
talented938423talented
tampered13279463tampered
tanged84622493tang__ed
tangled94214633tang_led
tangoed9318833tang_oed
tapered102612933ta_pered
tared69340053tar___ed
targe65227093targ__e_
targes74524593targ__es
targeting1137303targeting
tariffed1533723tariffed
tarletan845543tarletan
tarred74720283tar__red
tarried83914133tar_ried
tarter64023563tar__ter
tartrated1096643tartrated
tarweeds1244273tarwe_eds
tasseled935593tasseled
tasted74123973ta__sted
tatted74920533ta__tted
tattered92011443tattered
taunted84310963ta_unted
tauted75317113ta__uted
tautened935423tautened
telneted935073telneted
terete6319333ter_ete_
tergite8311003tergite_
tergites9310543tergites
threated1259203threated
threeped1454373threeped
throated1247923throated
thrusted1265223thrusted
ticketed15146643ticketed
togated94410663t_ogated
toileted936993toileted
tormented1245963tormented
trabeated1246843trabeated
trajected1944043trajected
trameled11309073trameled
trapesed1136473trapesed
traveled12349453traveled
treated83618703t_reated
treed65626733t_r_e_ed
trotted83711283t_rotted
trusted83412793t_rusted
trysted11428273t_rysted
turgite837973turgite_
turgites937783turgites
tweeted11336583t_weeted
valeted1139013va_leted
variated121211393variated
wagered12299333wa_gered
warted104223233war__ted
waughted1643483waughted

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.186960704.3
2DLD Change Limit1461621597.51619446.8
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.76223021.3
 
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.