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

140 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
aphonia12271188(None) 
aphonias132611141aphonias
aphonic142713391aphonic
acholia1239972acholia
ammonia1148692ammonia
aphagia13247662aphagia
aphasia122510872aphasia
aphelia1249422aphelia
aphonics15259522aphonics
aphotic142913112aphotic
aporia8315862ap_oria
atonia63816512a_tonia
daphnia1345052daph_nia
mahonia1238442mahonia
phobia13278592_phobia
phonic133315202_phonic
abrosia939273abrosia
acapnia1145913acapnia
achenial1348283achenial
acholias1349573acholias
acromia1139963acromia
acronic112814693acronic
actinia91710853actinia
adonis7314063a_donis
aeonian738353a_eonian
aeonic83517043a_eonic
aerobia939463aerobia
agnosia837643agnosia
agonic93515143a_gonic
allodia8128793allodia
alodia71112453a_lodia
alphosis1347273alphosis
amboina1137963amboina
ammoniac1455743ammoniac
ammonias1247943ammonias
ammonic1349163ammonic
amnia75918643a__mnia
amphibia1744403amphibia
amphora1446923ampho_ra
anhedonia1352803anhedonia
anhinga11104813anhinga
anionic9312873anionic
annona648873annon_a
anopia83412393a_nopia
anoxia133510023a_noxia
anthodia1247803anthodia
aphagias14237343aphagias
aphanite1348773aphanite
aphasiac15286593aphasiac
aphasias132710433aphasias
aphasic142810063aphasic
aphelian1376963aphelian
aphesis12610513aphesis
aphetic142912853aphetic
aphid115515393aph__id
aphidian1445533aphidian
aphis105917133aph__is
aphorise1339983aphorise
aphorism1548643aphorism
aphorist13412503aphorist
aphorize2249043aphorize
aphtha1444483aph_tha
apimania1245463apimania
aplasia92510803aplasia
apnea73413413ap__nea
apnoea867093apno_ea
apnoeic1147613apnoeic
apologia1147723apologia
aporias9315133ap_orias
appoint11612483appoint
apraxia1646893apraxia
apron7318833apron__
aproned10311503aproned
aproning11311793aproning
aprons8316993apron_s
aprotic112715233aprotic
apteria9312913apteria
armonica1276863armonica
asphyxia2342873asphyxia
asthenia1167713asthenia
atonias73315993a_tonias
atonic83420473a_tonic
avionic1237693avionic
axonic154312723a_xonic
azonic175513153a_zonic
bauhinia1343293bauhinia
begonia1047213begonia
daphnias1444683daph_nias
dysphonia1844423dysphonia
ephori1139603ephori_
euphonic15117813euphonic
euphoria13116863euphoria
gonia64117533__gonia
haplopia1544783haplopia
honda9414983__honda
japonica19114033jap_onica
mahonias1348053mahonias
oogonia846483oogonia
opsonic1137253opsonic
opsonin946013opsonin
pennia84412973_pennia
phelonia1347043_phelonia
phenix1837133_phenix
phobias14228183_phobias
phobic153010063_phobic
phoenix1944353_phoenix
phon95925383_phon__
phonal11310383_phonal
phone105621933_phon_e
phoned124014553_phoned
phones114121213_phones
phoney143612983_phoney
phonics143110723_phonics
phonied133710563_phonied
phonier122710633_phonier
phonies123717513_phonies
phonily1537103_phonily
phoning13312053_phoning
phono104917023_phon_o
phonon114012033_phonon
phonos114114793_phonos
phons105221143_phon_s
phony136715443_phon_y
photic133316423_photic
pionic103515953_pionic
podia8415283_p_odia
pogonia1048933pogonia
raphia113511263raph__ia
saphena1235863saphen_a
saponin9310253sap_onin
scholia1237823scholia
siphonic1547983siphonic
sphenic1449093sphenic
splenia948313splenia
sthenia1058503sthenia
syconia1248293syconia
thoria93012883_thoria
tithonia1195613tithonia
typhonic1847173typhonic
valonia1048303valonia

Search took 9 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.1531167915.0
2DLD Change Limit1340271407.80017182.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.99922339.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.