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

139 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
archive15461048(None) 
archine125817051archine
archived17355991archived
archives16399551archives
achieve1545022a_chieve
active11313742a_ctive
archaise1348472archaise
archaize2246212archaize
archfoe1544722archfoe
archil11611572archi_l
archils12510532archils
archines133815252archines
arching136216692arching
archival1645782archival
arcsine94512392arcsine
arrive91311792ar_rive
chive135117622__chive
abrasive1345753abrasive
abusive1245283abusive
ache96829823a_ch__e
achene11313813a_chene
achier113914263a_chier
achieved1743713a_chieved
achiever1643843a_chiever
achieves1645523a_chieves
aching126521973a_ching
achiote1239213a_chiote
actives12311523a_ctives
alcaide1088453alcaide
alcove1178083alc_ove
alive85722513a__live
amative12311733amative
amusive1246253amusive
anchovy1843953anchovy
arabize1849343arabize
arcade91013643arc_ade
arcane81216743arc_ane
arch98628443arch___
archaea12137613archaea
archaic1438823archaic
archaised1545483archaised
archaises1448393archaises
archaism1547103archaism
archaist1349853archaist
archaized2445073archaized
archaizer2344523archaizer
archaizes2346443archaizes
archduke1842343archduke
archean1269123archean
arched125717323arch_ed
archer115016243arch_er
archers124414573archers
archery15478063archery
arches114822043arch_es
archfoes1644993archfoes
archings14499863archings
architect1644683architect
architrave1852313architrave
archiving1844763archiving
archivist1745493archivist
archivolt1753343archivolt
archly1437353arch_ly
archon11311753arch_on
archons12311583archons
archrival1743383archrival
archway1844893archway
arcing95819643arc_ing
arcking145811963arcking
arcsines104010343arcsines
arctic10313513arcti_c
arctics1138953arctics
arcuate9311963arcuate
arenite71017713arenite
arise56436433ar__ise
armhole1236943armhole
armlike1348553armlike
armoire938133armoire
arrived11127353ar_rived
arriver10117793ar_river
arrives101311513ar_rives
arshin9312173arshi_n
arshins10312573arshins
arsine64021043ar_sine
ascribe1147743ascribe
awhile1257793a_while
beehive1554033beehive
chide115321013__chide
chile105626893__chile
chime125322593__chime
chine105231723__chine
chives144317593__chives
chivy164810363__chivy
deceive1337813deceive
drive95318003dr__ive
erective13311833erective
erosive1039193erosive
errhine1036593errhine
farcie114816473farc_i_e
fictive1537023fictive
hive106029673___hive
macchie1647193macchi_e
machine14313493machine
marchese15358913marchese
marching164312193marching
marchlike2044793marchlike
narceine1046753narceine
narghile1244033narghile
orchid1289573orchi_d
orchids1377213orchids
orchil1158653orchi_l
orchils1277703orchils
orchis11710773orchi_s
orchises1338773orchises
orective1339353orective
parching164313053parching
parchisi15368933parchisi
perceive1546963perceive
predive13511083predive
rachial122012173rachial
rachides141511223rachides
rachis114017653rachi_s
rachises131412413rachises
raphide13138073raphide
rawhide14134973rawhide
receive1239733receive
regive104814323_regive
rehire95415863_rehire
reive85522943_r_eive
relive95120783_relive
revive124914823_revive
rive75537723_r__ive
scrive115414943_scrive
shive114423423__shive
tardive1136893tar_dive
techie11511723techi_e
tractive13310043tractive
trichite1349333trichite
urchin1138743urchi_n
urchins1238863urchins

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271398.72015370.1
3Display Results1391390.0931494.6
 (SQL Overall)1786911398.96919923.2
 
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.