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

80 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
aphtha144448(None) 
aphthae1544701aphthae
naphtha1542921naphtha
apathy1437032apathy
naphthas1643252naphthas
acantha1254663acantha
aceta74017353acet_a
acta69524803a_ct_a
adyta936853adyt_a
agha87417303a__gha
agita6315423agit_a
aha611246643a___ha
airth85621023airth_
airths95414253airths
aloha8513623a_loha
alpha1049653a_lpha
althea938213althea
altho86312603a_ltho
amphora1446923amphora
anta46839583a_nt_a
antra56521923a_ntra
aorta55922573aort_a
apache134210783apache
aphagia13247663aphagia
aphasia122510873aphasia
aphelia1249423aphelia
aphetic142912853aphetic
aphid115515393aph_id
aphids125110843aphids
aphis105917133aph_is
aphonia122711883aphonia
aphotic142913123aphotic
aphthous1694873aphthous
apish105116633apish_
apnea73413413ap_nea
apnoea867093apnoea
aporia8315863aporia
apothem1444643apothem
apt57352543ap_t__
apter76120203ap_ter
aptly105111813ap_tly
ashtray13805553ashtray
asthma11126563asthma
atma68121773a__tma
azoth17389903azoth_
azoths18366203azoths
bertha11429173bertha
capita102913773capit_a
daphnia1345053daphnia
epha9310053ep__ha
ephah1337063ephah_
ephahs1435503ephahs
haha107821063__haha
haphtara1653273haphtara
maltha1137513maltha
naphthol1662403naphthol
naphthyl1951633naphthyl
naphtol12124023naphtol
pacha126518063_pacha
pakeha1533933pakeha
pasha105417183_pasha
pasta76624533past_a
path99134913_path_
paths105521383_paths
phpht1538063_phpht
pht86030523_pht__
phyla13469183_phyla
pita65436433_pit_a
pith95432693_pith_
piths105817543_piths
pithy135614463_pithy
pitta75018693_pitta
quotha18365113quotha
raphia113511263raph_ia
saphena1235863saphena
sapota8310213sapot_a
spathal1236263spathal
spathe115115693spathe
sputa74612963sput_a
tapeta8310693tapet_a

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 Filter1786911127160.420425454.8
2DLD Change Limit112716806.39017639.4
3Display Results80800.0332424.2
 (SQL Overall)178691806.84326113.0
 
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.