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

108 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
aphasic14281006(None) 
aphasia122510871aphasia
aphasiac15286591aphasiac
aphasics15257231aphasics
phasic133612051_phasic
anaphasic1645422anaphasic
aphagia13247662aphagia
aphasiacs16254222aphasiacs
aphasias132710432aphasias
aphesis12610512aphesis
aphetic142912852aphetic
aphonic142713392aphonic
aphotic142913122aphotic
aplasia92510802aplasia
aplastic1249242aplastic
apraxic1846292apraxic
biphasic1744182biphasic
diphasic1645802diphasic
phasis114614922_phasis
phatic133014412_phatic
physic16288472_physic
abasia8712953a_basia
acephalic1844933acephalic
acmatic13311693acmatic
acrasia9310033acrasia
acrasin9311223acrasin
agamic113110563a_gamic
agaric93513633a_garic
aggadic1254813aggadic
aghas97014873aghas__
aghast105711373aghas_t
agnatic10310973agnatic
agravic1345893agravic
alcaic1039983alca_ic
aliphatic1645343aliphatic
alkalic13146973alkalic
alphas1139513alphas__
alphosis1347273alphosis
amnesic1137183amnesic
anisic8313793a_nisic
aphagias14237343aphagias
aphanite1348773aphanite
aphanitic1646013aphanitic
aphelia1249423aphelia
apheses12610703apheses
aphid115515393aph__id
aphis105917133aph__is
aphonia122711883aphonia
aphonics15259523aphonics
aplasias10279233aplasias
aplitic11311743aplitic
apneic1078623ap_neic
apnoeic1147613apnoeic
apoapsis1244093apoapsis
apogamic1545013apogamic
apogeic1246603apogeic
apophasis1646993apophasis
apractic1448303apractic
apraxia1646893apraxia
aprotic112715243aprotic
apsis75718293ap__sis
aquatic1838113aquatic
arabic10312733a_rabic
archaic1438823archa_ic
arkosic1346063arkosic
asphaltic1644603asphaltic
aspheric1547983aspheric
astasia7310933astasia
astatic9514193astatic
atavic11189293a_tavic
ataxic15169203a_taxic
atresic9310003atresic
aviatic1239243aviatic
basic96220523__basic
bibasic1345643bibasic
cephalic1777903cephalic
chasmic16177983_chasmic
dibasic1246033dibasic
dysphasic2053833dysphasic
emphasis15117673emphasis
emphatic1747863emphatic
ephas10311543ephas__
ephebic1646513ephebic
oghamic1544043oghamic
ophitic1439213ophitic
pachalic1757273pachalic
panic93923903_p_anic
pashalic1546183pashalic
phallic1447293_phallic
phase104617213_phas_e
phased124011973_phased
phases114618403_phases
phasing133211673_phasing
phasmid15267603_phasmid
phobic153010073_phobic
phonic133315213_phonic
photic133316443_photic
phylic16279553_phylic
physics17265963_physics
physis14359663_physis
pianic103714123_pianic
plasmic13249113_plasmic
plastic112815063_plastic
prophasic1848473prophasic
sebasic1146893sebasic
spastic11310383sp_astic
sphenic1449093sphenic
spheric14510073spheric

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.406440125.6
2DLD Change Limit1340271085.98622390.1
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.43827755.7
 
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.