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

194 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
racketed1516912(None) 
bracketed1855861bracketed
jacketed22146531jacketed
packeted17148281packeted
racheted14149501racheted
rocketed15157791rocketed
bucketed1736762bucketed
cacheted16148232cacheted
casketed1534952casketed
cricketed1854682cricketed
crocketed1845122crocketed
dackered16116892dackered
docketed16156582docketed
faceted13509562fac_eted
lackered15108672lackered
lackeyed18104512lackeyed
marketed1537322marketed
picketed17167382picketed
pocketed17147142pocketed
rabbeted1334442rabbeted
racemed1237012rac_emed
racked134526082rack__ed
racket125229422racket__
racketeer15174632racketeer
racketier15165412racketier
rackets134916872racket_s
rackety16499112racket_y
ratcheted1554782ratcheted
rejacketed2442272rejacketed
rocketer14158332rocketer
sacheted14127832sacheted
socketed15177342socketed
ticketed15146642ticketed
acceded1336093_acceded
accented13107773_accented
accepted15105383_accepted
accreted1336333accreted
ackee115825363_acke_e_
ackees124914573_acke_es
acted88521733_ac__ted
arcked136211943arck__ed
arcuated1138803arcuated
baccated15148373baccated
backdated1946483backdated
backed155725723back__ed
backhoed2047003backhoed
basseted1136743basseted
bickered17108003bickered
blackened1845273blackened
blanketed1643913blanketed
bracket154117233bracket__
brackets163310433bracket_s
bracted12410933brac__ted
cackled164613293cack_led
cankered153010223cankered
carpeted1338943carpeted
cockered17710213cockered
cockeyed2096123cockeyed
cracked163514743crack__ed
crackled17428863crack_led
cricketer1744563cricketer
crocheted1745313crocheted
daikered1495223daikered
darkened1435943darkened
dickered16117533dickered
excreted1846153excreted
facete115014833fac_ete_
facetted1445743facetted
fracted1339373frac__ted
galleted1038213galleted
garreted1057523garreted
hacked164923513hack__ed
hackee154921833hacke_e_
hackees165014103hacke_es
hackled173312483hack_led
hackneyed2242233hackneyed
hankered16289443hankered
harkened1637483harkened
hawkeyed2242403hawkeyed
jacked204817523jack__ed
jacket194720673jacket__
jackets205011373jacket_s
jockeyed2563413jockeyed
junketed2033523junketed
knackered1543683knackered
lacked135324653lack__ed
lactated1138863lactated
lakebed1434783la_kebed
lanceted1137073lanceted
lappeted13255833lappeted
machete14310883machete_
machetes1539633machetes
mackerel1644863mackerel
mackled164111913mack_led
marketer1437383marketer
nickeled15115513nickeled
nickered15117023nickered
packaged18115753packaged
packed154822603pack__ed
packet144726503packet__
packets155114773packet_s
palleted1139863palleted
pargeted1238673pargeted
picketer16187433picketer
pocketer16157373pocketer
puckered1736103puckered
rabbited1334763rabbited
raced87635313rac___ed
raceme1039733rac_eme_
racemes1139093rac_emes
rachet115028973rachet__
rachets124516833rachet_s
racker124824553rack__er
rackers134320453racke_rs
racketeered1851253racketeered
racketeers16153633racketeers
racketiest1643903racketiest
racketing1647873racketing
rackle123917293rack_le_
raclette1047643raclette
raclettes1147013raclettes
radiated102512593radiated
rafted104714703ra__fted
raftered1237663raftered
ragouted1034423ragouted
ragweed1235073ragwe_ed
raked105831423ra_k__ed
rakee96031173ra_ke_e_
rakees104516973ra_ke_es
ranked114620743rank__ed
rankled123910653rank_led
ranted74324703ra__nted
rapiered1136053rapiered
rappeled1335003rappeled
rated65441383ra___ted
ratted74923343ra__tted
rattened9218623rattened
raveled114113633ra_veled
ravened115012283ra_vened
razeed163710013ra_ze_ed
reacceded1573993reacceded
reaccented1544893reaccented
reaccepted1743323reaccepted
reacted103015713reac__ted
recanted112513513recanted
receded112713043rec_eded
rechewed1735633rechewed
recited104319103rec_ited
recked134821803reck__ed
reckoned1546953reckoned
recoated113416783recoated
recrated112918603recrated
recreated12412533recreated
rekeyed1536163r_ekeyed
remarketed1753583remarketed
richened1435953richened
ricked136523623rick__ed
ricketier15134583ricketier
rickets134915093ricket_s
rickety16478313ricket_y
riveted11258573r_iveted
rocked135022323rock__ed
rocket125425283rocket__
rocketeer15174493rocketeer
rocketers15186883rocketers
rocketry1744503rocketry
rockets134615363rocket_s
rockweed1843313rockweed
roqueted1834653roqueted
rucked134718763ruck__ed
ruckled144111033ruck_led
sacked135525213sack__ed
secreted1138633secreted
sickened1546783sickened
slackened1644243slackened
suckered1537833suckered
tableted1137533tableted
tacked134723943tack__ed
tacket124627493tacket__
tackets134914363tacket_s
tackled143913183tack_led
targeted1037483targeted
thicketed1943613thicketed
tracheated1646333tracheated
tracked143716133track__ed
trinketed1444253trinketed
tuckered1535963tuckered
unbracketed2051533unbracketed
vacated1349353vac_ated
valeted1139013va_leted
wakened1546873wa_kened
wracked174110113wrack__ed
yachted1634853yac_hted
yacked164516793yack__ed

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.1601116818.8
2DLD Change Limit1461621947.09320606.5
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.32924381.4
 
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.