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

91 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
archaea1213761(None) 
archaeal13115461archaeal
archaean13135161archaean
althaea1044352althaea
arcana8912582arc_ana
archaeans14134142archaeans
archaeon13134072archaeon
archaic1438822archaic
archean1269122archean
arched125717322arch_ed
archer115016242arch_er
arches114822042arch_es
ache96829823a_ch_e_
ached119227833a_ch_ed
aches106132293a_ch_es
achier113914263a_chier
althaeas1144213althaeas
althea938193alth_ea
anchusa1244333anchusa
arcade91013643arc_ade
arcaded1178973arcaded
arcades101113193arcades
arcadia1039703arcadia
arcane81216743arc_ane
arced88224163arc__ed
arch98628443arch___
archaical1645903archaical
archaise1348473archaise
archaised1545483archaised
archaises1448403archaises
archaism1547103archaism
archaist1349863archaist
archaize2246213archaize
archaized2445073archaized
archaizer2344523archaizer
archaizes2346443archaizes
archangel1544313archangel
archers124414573archers
archery15478063archery
archfoe1544723archfoe
archfoes1644993archfoes
archil11611573arch_il
archils12510533archils
archine125817053archine
archines133815253archines
arching136216693arching
archival1645783archival
archive154610483archive
archived17355993archived
archives16399553archives
archly1437353arch_ly
archness1337513archness
archon11311753arch_on
archons12311583archons
archway1844893archway
archways1944063archways
arcked136211943arc_ked
arcuate9311963arcuate
arcuated1138803arcuated
arcuses94814693arcuses
area45843393ar___ea
areae55229743ar_eae_
argala74712673ar_gala
arhat8327093ar_ha_t
arhats9312973ar_hats
armada938783ar_mada
armchair1543023armchair
barchan1469133barcha_n
barchans1588683barchans
chaeta11310683__chaeta
cochlea1435343cochlea
earthpea1343423earthpea
furcraea1342193furcraea
larchen12479623larch_en
larches124416443larch_es
marched153813403march_ed
marchen143312073march_en
marcher143912973march_er
marches143921173march_es
marchesa15346883marchesa
nuchae11218513nuchae_
ochrea11316643_ochrea
orchard1346933orchard
parched154013693parch_ed
parches143720003parch_es
rachet115028973rach_et
raphae114311733raphae_
rhea75017433_r_h_ea
trachea12311673trach_ea
trehala1045953trehala
trochlea1345193trochlea

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 Filter1786911340270.403443402.0
2DLD Change Limit134027916.45620760.1
3Display Results91910.0303033.3
 (SQL Overall)178691916.88925938.6
 
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.