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

139 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
targeting113730(None) 
pargeting1338281pargeting
carpeting1439482carpeting
margenting1446152margenting
marketing1636512marketing
pargetings1443712pargetings
pargetting1444942pargetting
retargeting1343932retargeting
tableting1236342tableting
tarting84222652tar__ting
ageing84213403_a_ge_ing
agenting1039383_a_genting
agreeing10295903_agreeing
angeling102811733_angeling
angering102113803_angering
argentine1047893_argentine
argling92812733_arg_ling
arguing9248733_arg_uing
arresting1038633_arresting
badgering1436963badgering
barbering14229683barbering
barging114018483barg__ing
barreling1238043barreling
bartering122313643bartering
basseting1236153basseting
budgeting1444023budgeting
cacheting1737153cacheting
cageling12310843ca_geling
careening12310013careening
careering12311203careering
carpetings1544213carpetings
carting104228283car__ting
casketing1635383casketing
corseting12312173corseting
curveting1535353curveting
daggering13246113daggering
dangering12239303dangering
darkening1535683darkening
darting94020663dar__ting
faceting1438783fa_ceting
faggoting1543313faggoting
fagoting1336283fa_goting
farseeing1344383farseeing
farting114120753far__ting
ferreting13127693ferreting
fidgeting1544523fidgeting
forgetting1544663forgetting
galleting1137623galleting
gardening1236513gardening
gargling11239203garg_ling
garmenting1445483garmenting
garnering11298083garnering
garoting10510703gar_oting
garotting1136103garotting
garroting1136953garroting
gartering112111573gartering
greeting103112353_greeting
hardening1438023hardening
harkening1746923harkening
harvesting1744413harvesting
jacketing2345643jacketing
jargoning1845983jargoning
karting123716063kar__ting
laagering1136833laagering
lagering102212313la_gering
lariating10311783lariating
margining1337603margining
marketings1743163marketings
marting103325013mar__ting
marveling1537103marveling
narrating10310353narrating
packeting1836853packeting
palleting1238733palleting
parceling1438443parceling
parenting12611583parenting
parging113318603parg__ing
parleying1536113parleying
parqueting2243633parqueting
parroting1239153parroting
parting103527383par__ting
rabbeting1445183rabbeting
racheting1537793racheting
racketing1647873racketing
saggering12197793saggering
staggering13194583staggering
stargazing2193323stargazing
starting93116173star__ting
starveling1444263starveling
tabering112211423ta_bering
tabletting1344083tabletting
tagging103014913ta_g_ging
tailgating1244903tailgating
tainting93613583ta_inting
tampering1438453tampering
tangerine1048403tangerine
tanging93419523tang__ing
tangling101712543tang_ling
tangoing10177893tang_oing
tapering112112503ta_pering
target75028903target___
targeted1037483target_ed
targets84314223target__s
tariffing1644113tariffing
taring73932283tar___ing
tarletan845543tarletan_
tarletans944643tarletans
tarring83318303tar__ring
tarrying12146723tar_rying
tasseling1035853tasseling
tasting84624213ta__sting
tattering102212323tattering
tatting84019523ta__tting
taunting93510933ta_unting
tautening1035843tautening
tauting83316383ta__uting
telneting1035593telneting
threating131010043threating
threeping15104803threeping
throating1398383throating
thrusting1335003thrusting
ticketing1635633ticketing
tingeing10198553tinge_ing
toileting1036263toileting
tormenting1345693tormenting
trajecting2044293trajecting
trameling1249053trameling
trapesing1247263trapesing
traveling1349053traveling
treating92519613t_reating
treeing83414303t_r_eeing
trotting92510913t_rotting
trueing83410183t_rue_ing
trusting93411653t_rusting
trysting12267053t_rysting
tweeting12267033t_weeting
valeting1238843va_leting
variating13310943variating
wagering13219523wa_gering
waughting1743123waughting

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411397.37620152.0
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.59223536.7
 
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.