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

113 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
typical143634(None) 
atypical1544681atypical
topical1139951topical
apical10913902_apical
cynical1437872cynical
epical10413392_epical
lyrical1236492lyrical
pical95524372__pical
styptical1643962styptical
tical76021492t__ical
toxical1637642toxical
tropical1248732tropical
typal105311152typ__al
typic124511962typic__
typically1946082typically
untypical1643642untypical
abapical1444943abapical
apicals1159923_apicals
atomical1248903atomical
atypic13337653atypic__
atypically2045743atypically
capital112311523capital
comical13312223comical
conical11316203conical
cryptical1844693cryptical
cubical1338463cubical
cyclical1445653cyclical
domical1239373domical
espial839543espi_al
ethical1238443ethical
ethnical1346363ethnical
finical1239693finical
haptical1547343haptical
helical12311153helical
hyoidal1444803hyoidal
hyphal1736413hyp_hal
laical8312323_laical
lexical1637363lexical
logical1038513logical
magical1239783magical
medical12312513medical
metical11315363metical
mimical1339233mimical
musical1139553musical
myrica1336833myrica_
myricas1436753myricas
mystical1546933mystical
mythical1845033mythical
nodical1049863nodical
nontypical1754543nontypical
optical1149863optical
orphical1546733orphical
physical1845703physical
pial65636703__pi_al
pibal95217323__pibal
pica85831493__pica_
picas94626523__picas
picul95015363__picul
pipal95118353__pipal
plical10411683_plical
radical103312793radical
satyrical1445033satyrical
septical1259363septical
spica94717943_spica_
spicae104313703_spicae
spicas104715823_spicas
spinal84915313_spinal
spiral83715343_spiral
spital83813873_spital
statical1039423statical
sterical10311253sterical
stoical9310283stoical
syndical1445373syndical
tactical1248843tactical
tapetal938273tapetal
tapioca1144633tapioca_
tapiocas1244783tapiocas
taxicab1843413taxicab
telial65815363teli_al
tepal76319583tep__al
thecal113310303t_hecal
thetical1349123thetical
tibial849843tibi_al
ticals83214713t__icals
tidal64516443t__idal
tincal83913363t_incal
tipcat10312653tip_cat
topic95721503topic__
topically1649533topically
topics104714583topic_s
tragical1148213tragical
trial54926353t_ri_al
tribal8611133t_ribal
trinal6516963t_rinal
tropicals1345613tropicals
tunica8379813tunica_
tunicae9328143tunicae
turrical1046203turrical
tymbal13236823ty_mbal
tympanal15243283tympanal
typebar1442993typebar
typecase1543463typecase
typecast1545273typecast
typhoidal1853183typhoidal
typicality2053243typicality
typier1137333typi_er
typiest1238203typiest
typify1734523typi_fy
typing124110583typi_ng
typist1139823typi_st
typists1236173typists
vatical1239983vatical
vesical12159813vesical

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.470380193.6
2DLD Change Limit1340271135.56024105.6
3Display Results1131130.0333424.2
 (SQL Overall)1786911136.06329472.4
 
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.