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

142 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
sacheted1412783(None) 
cacheted16148231cacheted
racheted14149501racheted
faceted13509562fac_eted
jacketed22146532jacketed
machete14310882machete_
machetes1539632machetes
packeted17148282packeted
racketed15169122racketed
ratcheted1554782ratcheted
sachet114725772sachet__
sachets123914102sachet_s
satcheled1544422satcheled
schemed1577752s_chemed
secreted1138632secreted
socketed15177342socketed
yachted1634852yach_ted
acceded1336093_acceded
accented13107773_accented
accepted15105373_accepted
accreted1336333accreted
ached119227833_ach__ed
achene11313813_achene_
achenes12313493_achenes
achieved1743713_achieved
acted88521733_ac__ted
adhered1239233_adhered
baccated15148373baccated
bached145519893bach__ed
basseted1136743basseted
bracketed1855863bracketed
bucketed1736763bucketed
cached145419203cach__ed
cachet134526413cachet__
cachets145014263cachet_s
carpeted1338943carpeted
casketed1534953casketed
cathected1744543cathected
catheter1338153catheter
cheated134416343__cheated
chefed155010563__chefed
chested133811673__chested
chewed154415013__chewed
chuted124611843__chuted
crocheted1745313crocheted
dackered16116893dackered
docketed16156583docketed
escheated1546273escheated
eschewed1743443eschewed
excreted1846153excreted
facete115014833fac_ete_
facetted1445743facetted
fathered151510433fathered
galleted1038213galleted
garreted1057523garreted
gathered13149373gathered
hachured1744393hachured
hatcheled1844223hatcheled
kashered1636403kashered
lackered15108673lackered
lackeyed18104513lackeyed
lactated1138863lactated
lanceted1137073lanceted
lappeted13255833lappeted
lathered121512323lathered
lechered1437523lechered
lichened1435753lichened
lichted13268803lich_ted
machined1637303machined
marketed1537323marketed
ochered132610283_ochered
palleted1139863palleted
pargeted1238673pargeted
picketed17167383picketed
pocketed17147143pocketed
rabbeted1334443rabbeted
racemed1237013rac_emed
rachet115028973rachet__
rachets124516833rachet_s
rechewed1735633rechewed
richened1435953richened
rocketed15157793rocketed
sabered103213023sa_bered
saccate111311763saccate_
sachem134012223sach__em
sachemic1746083sachemic
sachems14348903sache_ms
sacked135525213sac__ked
sacred94917103sac__red
saddened1135343saddened
safetied1244663sa_fetied
saggered11237553saggered
sainted84114243sa_inted
salted74121203sa__lted
saluted84511703sa_luted
saphead1357773saphe_ad
sapheaded1644183sapheaded
sashayed1543553sashayed
sashed105622943sash__ed
sated66238533sa___ted
satiated9311603satiated
sauted74119603sa__uted
sauteed8349613saute_ed
scanted104114393s_canted
scarted104816123s_carted
scatted103512773s_catted
scented102811883s_cented
scheme1379633s_cheme_
schemer1477953s_chemer
schemes1489663s_chemes
scooted103612273s_cooted
scouted104112033s_couted
screed95718923s_cre_ed
screwed135710653s_crewed
seceded11319203sec_eded
secrete9311073secrete_
secreter1038503secreter
secretes10410473secretes
sheeted113813033s_heeted
shewed134716183s__hewed
shuted103913163s__huted
sickened1546783sickened
sighted123111523sigh_ted
signeted1035973signeted
slackened1644243slackened
slathered13148533slathered
sleeted83113223s_leeted
sonneted936183sonneted
sphered133512313s_phered
succeed1235983succe_ed
suckered1537833suckered
syphered1755013syphered
tableted1137533tableted
targeted1037483targeted
ticketed15146643ticketed
tochered1437913tochered
tracheated1646333tracheated
unchewed1735803unchewed
vacated1349353vac_ated
valeted1139013va_leted
wauchted1753373wauch_ted
yachter1534913yach_ter

Search took 9 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.1731032896.0
2DLD Change Limit1461621428.29617618.4
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.53220943.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.