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 “archived” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
archived1735599(None) 
archive154610481archive_
archives16399551archives
achieved1743712a_chieved
archaised1545482archaised
archaized2445072archaized
arched125717322arch__ed
archine125817052archine_
archines133815252archines
archival1645782archival
arrived11127352ar_rived
ached119227833a_ch__ed
achier113914263a_chi_er
achieve1545023a_chieve
achiever1643843a_chiever
achieves1645523a_chieves
active11313743a_ctive_
actives12311523a_ctives
alcoved1375613alc_oved
anchored1438593anchored
arabized2047173arabized
arcaded1178973arc_aded
arced88224163arc___ed
archaea12137613arch_aea
archaise1348473archaise_
archaises1448403archaises
archaize2246213archaize_
archaizer2344523archaizer
archaizes2346443archaizes
archer115016243arch__er
arches114822043arch__es
archfiend1841933archfiend
archfoe1544723archfoe_
archfoes1644993archfoes
archil11611573archi__l
archils12510533archi_ls
arching136216693archi_ng
archings14499863archings
architect1644683architect
archiving1844763archiving
archivist1745493archivist
archivolt1753343archivolt
archrival1743383archrival
arcked136211943arc__ked
arcsine94512393arcsine_
arcsines104010343arcsines
arcuated1138803arcuated
ariled75620323ar__iled
arrive91311793ar_rive_
arriver10117793ar_river
arrives101311513ar_rives
ascribed1374693ascribed
chided135113963__chided
chimed145814833__chimed
chined125620063__chined
chive135117623__chive_
chives144317593__chives
chivied16368383__chivied
deceived1535893deceived
hived125217913___hived
machined1637303machined
marched153813403march__ed
orchid1289573orchi__d
orchises1338773orchises
parched154013693parch__ed
perceived1744353perceived
racheted14149503racheted
rachides141511223rachides
rachises131412413rachises
rawhided16153073rawhided
received1437983received
rehired115013153_rehired
reived104518133_r_eived
relived115114683_relived
revived144211653_revived
rived94825613_r__ived
scrived134511113_scrived

Search took 7 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.423422437.4
2DLD Change Limit146162776.50022486.5
3Display Results77770.0302566.7
 (SQL Overall)178691776.95325699.8
 
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.