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

166 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
topical113995(None) 
toxical1637641toxical
tropical1248731tropical
typical1436341typical
apical10913902_apical
atomical1248902atomical
atypical1544682atypical
comical13312222comical
conical11316202conical
domical1239372domical
epical10413392_epical
logical1038512logical
nodical1049862nodical
optical1149862_optical
pical95524372__pical
stoical9310282sto_ical
tical76021492t__ical
topic95721502topic__
topically1649532topically
topics104714582topic_s
tropicals1345612tropicals
abapical1444943abapical
alogical1147763alogical
apicals1159923_apicals
atopic103514143atopic__
biotical1248863biotical
capital112311523capital
coccal9310223co_ccal
codicil1246813codicil
coital84117053co_ital
copal95621783cop__al
copycat1647593copycat
cortical12412213cortical
cosmical1448013cosmical
cotidal1038463cotidal
cubical1338463cubical
cynical1437873cynical
domicil1246433domicil
dropsical1443723dropsical
erotical101911983erotical
espial839543espi_al
ethical1238443ethical
ethnical1346363ethnical
finical1239693finical
focal104917673fo__cal
fornical1347793fornical
gnomical1346683gnomical
haptical1547343haptical
helical12311153helical
hospital1344743hospital
iconical1248203iconical
ironical1049963ironical
jovial1636543jovi_al
laical8312323_laical
lexical1637363lexical
local74820273lo__cal
lorica8310443lorica_
loricae938253loricae
lyrical1236493lyrical
magical1239783magical
medical12312513medical
metical11315363metical
mimical1339233mimical
modica11310063modica_
musical1139553musical
nominal92712373nominal
nopal75517103nop__al
ocicat101412813_ocicat
ogival1035873_ogival
opal66923523_op__al
optimal1145783_optimal
orphical1546733orphical
pial65636703__pi_al
pibal95217323__pibal
pica85831493__pica_
picas94626523__picas
picul95015363__picul
pipal95118353__pipal
plical10411683_plical
poetical12311533poetical
pollical1247953pollical
radical103312793radical
septical1259363septical
social8813333soci_al
somital939403somital
spica94717943_spica_
spicae104313703_spicae
spicas104715823_spicas
spinal84915313_spinal
spiral83715343_spiral
spital83813873_spital
statical1039423statical
sterical10311253sterical
styptical1643963styptical
tactical1248843tactical
tapetal938273tapetal
tapioca1144633tapioca_
tapiocas1244783tapiocas
taxicab1843413taxicab
telial65815363teli_al
tepal76319583tep__al
thecal113310303t_hecal
thetical1349123thetical
thoracal1344913thoracal
tibial849843tibi_al
ticals83214713t__icals
tidal64516443t__idal
tincal83913363t_incal
tipcat10312653tip_cat
toecap1037323to_ecap
toil46536283to_i__l
tombal102311023to_mbal
tomcat101013453to_mcat
tonal53724303to__nal
tonic74727653tonic__
tonically14311143tonically
tonics83617863tonic_s
topaz16315323top__az
topcoat1179313topcoat
topful1136543top_ful
topfull1244153topfull
topi67830393topi___
topiary1245813topiary
topicality1744483topicality
toping94122993topi_ng
topis76025833topi__s
topkick1443143topkic_k
topkicks1542633topkicks
topsail976523topsail
topsoil977143topsoil
toric76529313toric__
torics85118353toric_s
toroidal966393toroidal
total55321823to__tal
toucan838193to_ucan
toxic145315623toxic__
toxically2147573toxically
toxicant1746293toxicant
toxics153910203toxic_s
tragical1148213tragical
trial54926353t_ri_al
tribal8611133t_ribal
trinal6516963t_rinal
troopial1045483troopi_al
tropic103014193tropic__
tropically1749843tropically
tropics113610653tropic_s
troupial1044183troupi_al
tunica8379813tunica_
tunicae9328143tunicae
turrical1046203turrical
typal105311153typ__al
typic124511963typic__
typically1946083typically
untypical1643643untypical
utopia8107883utopi_a_
utopian9126273utopi_an
utopias9117723utopi_as
vatical1239983vatical
vesical12159813vesical
vocal104715643vo__cal
vomica1336383vomica_
vomicae1445303vomicae
vortical1348863vortical
zodiacal2042243zodiacal
zooidal1745093zooidal

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 Limit1340271666.22021547.7
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.68926714.2
 
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.