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

130 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
jacketed2214653(None) 
packeted17148281packeted
racketed15169121racketed
bracketed1855862bracketed
bucketed1736762bucketed
cacheted16148232cacheted
casketed1534952casketed
dackered16116892dackered
docketed16156582docketed
faceted13509562fac_eted
jacked204817522jack__ed
jacket194720672jacket__
jackets205011372jacket_s
jockeyed2563412jockeyed
junketed2033522junketed
lackered15108672lackered
lackeyed18104512lackeyed
marketed1537322marketed
picketed17167382picketed
pocketed17147142pocketed
racheted14149502racheted
rejacketed2442272rejacketed
rocketed15157792rocketed
sacheted14127832sacheted
socketed15177342socketed
ticketed15146642ticketed
acceded1336103_acceded
accented13107773_accented
accepted15105383_accepted
accreted1336333accreted
ackee115825373_acke_e_
ackees124914583_acke_es
acted88521733_ac__ted
baccated15148373baccated
backdated1946483backdated
backed155725723back__ed
backhoed2047013backhoed
basseted1136743basseted
bickered17108003bickered
blackened1845273blackened
blanketed1643913blanketed
cackled164613303cack_led
cankered153010223cankered
carpeted1338953carpeted
cockered17710213cockered
cockeyed2096123cockeyed
cricketed1854683cricketed
crocketed1845123crocketed
daikered1495223daikered
darkened1435943darkened
dickered16117533dickered
excreted1846153excreted
facete115014833fac_ete_
facetted1445743facetted
galleted1038213galleted
garreted1057523garreted
hacked164923513hack__ed
hackee154921833hacke_e_
hackees165014103hacke_es
hackled173312493hack_led
hackneyed2242243hackneyed
hankered16289443hankered
harkened1637483harkened
hawkeyed2242403hawkeyed
jabbered2034433jabbered
jackbooted2651733jackbooted
jacker194417583jack__er
jackeroo2143743jackeroo
jackers204214453jacke_rs
jacketing2345643jacketing
jacketless2341763jacketless
jackies202912623jack_ies
jackleg2135043jack_leg
jackstay2443133jackstay
jaculated19289053jaculated
jauked18489013jauk__ed
jaunted15418563ja_unted
jockette2165033jockette
jockettes2254383jockettes
junketer1943713junketer
knackered1543683knackered
lacked135324653lack__ed
lactated1138863lactated
lakebed1434783la_kebed
lanceted1137073lanceted
lappeted13255833lappeted
machete14310883machete_
machetes1539633machetes
mackerel1644863mackerel
mackled164111923mack_led
marketer1437383marketer
nickeled15115513nickeled
nickered15117023nickered
packaged18115753packaged
packed154822603pack__ed
packet144726503packet__
packets155114773packet_s
palleted1139873palleted
pargeted1238683pargeted
picketer16187433picketer
pocketer16157373pocketer
puckered1736103puckered
rabbeted1334443rabbeted
racemed1237013rac_emed
racked134526083rack__ed
racket125229423racket__
racketeer15174633racketeer
racketier15165413racketier
rackets134916873racket_s
rackety16499113racket_y
ratcheted1554783ratcheted
rocketer14158333rocketer
sacked135525213sack__ed
secreted1138633secreted
sickened1546783sickened
slackened1644243slackened
suckered1537833suckered
tableted1137533tableted
tacked134723943tack__ed
tacket124627493tacket__
tackets134914363tacket_s
tackled143913193tack_led
targeted1037483targeted
thicketed1943613thicketed
tuckered1535963tuckered
vacated1349353vac_ated
valeted1139013va_leted
wakened1546873wa_kened
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.453394461.4
2DLD Change Limit1461621306.97020970.2
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.46923924.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.