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

136 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
archives1639955(None) 
archines133815251archines
archive154610481archive_
archived17355991archived
achieves1645522a_chieves
actives12311522a_ctives
archaises1448402archaises
archaizes2346442archaizes
arches114822042arch__es
archfoes1644992archfoes
archils12510532archi_ls
archine125817052archine_
archings14499862archings
archival1645782archival
archivist1745492archivist
arcsines104010342arcsines
arrives101311512ar_rives
chives144317592__chives
orchises1338772orchises
rachides141511222rachides
rachises131412412rachises
abrasives1444063abrasives
achenes12313493a_chenes
aches106132293a_ch__es
achier113914263a_chi_er
achiest12315183a_chi_est
achieve1545023a_chieve
achieved1743713a_chieved
achiever1643843a_chiever
achievers1743433a_chievers
achiness1339703a_chiness
achiotes1339003a_chiotes
active11313743a_ctive_
alcaides11117673alcaides
alcoves1297873alc_oves
alewives1444283alewives
anarchies1448183anarchi_es
anchovies1745753anchovies
aphides134711203a_phides
arabizes1969103arabizes
arcades101113193arc_ades
archaea12137613arch_aea
archaise1348473archaise_
archaised1545483archaised
archaisms1646073archaisms
archaists1446583archaists
archaize2246213archaize_
archaized2445073archaized
archaizer2344523archaizer
archaizers2443633archaizers
archdukes1942563archdukes
arched125717323arch__ed
archer115016243arch__er
archeries14411223archeries
archers124414573arch_ers
archfoe1544723archfoe_
archil11611573archi__l
arching136216693archi_ng
architect1644683architect
architects1772603architects
architraves1952183architraves
archiving1844763archiving
archivists1853913archivists
archivolt1753343archivolt
archivolts1852173archivolts
archness1337513archness
archons12311583arch_ons
archrival1743383archrival
archrivals1852363archrivals
archways1944063archways
arcsine94512393arcsine_
arctics1138953arcti_cs
arcuses94814693arc_uses
arenites8917103arenites
arises65233803ar__ises
armholes1347383armholes
armies85123693ar_mi_es
armoires1057623armoires
arrises71617583ar_rises
arrive91311793ar_rive_
arrived11127353ar_rived
arriver10117793ar_river
arrivers11137003ar_rivers
arshins10312573arshi_ns
arsines73518813ar_sines
ascites9312603asc_ites
ascribes1246193ascribes
beehives1644483beehives
chides124620473__chides
chiles115425303__chiles
chimes134922573__chimes
chines115029173__chines
chive135117623__chive_
chivies153412853__chivies
deceives1437903deceives
diarchies1546753diarchi_es
drives105117113dr__ives
duchies133312313duchi_es
dyarchies1844033dyarchi_es
eparchies1646973eparchi_es
errhines1136413errhines
exarchies2145213exarchi_es
farcies125317883farc_i_es
farmwives2041783farmwives
hives116925513___hives
kerchieves2251893kerchieves
larches124416443larch__es
machines15312893machines
marches143921173march__es
narceines1146583narceines
narghiles1343543narghiles
orchids1377213orchi_ds
orchils1277703orchi_ls
orchis11710773orchi__s
orchitis1346423orchitis
parches143720003parch__es
parchisis16318573parchisis
perceives1646313perceives
prelives13310383prelives
rachis114017653rachi__s
rachitis1348353rachitis
raphides14188393raphides
rawhides15145543rawhides
receives1339743receives
regives115014213_regives
rehires105016113_rehires
reives95723043_r_eives
relives104619443_relives
revives134715543_revives
rives85336003_r__ives
scrives124414273_scrives
shives124921413__shives
techies12513603techi_es
trichites1448883trichites
urchins1238863urchi_ns
vichies15310623vichi_es

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.436409841.7
2DLD Change Limit1461621367.23320207.7
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.71523161.5
 
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.