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

205 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
comical1331222(None) 
conical11316201conical
cosmical1448011cosmical
domical1239371domical
atomical1248902atomical
chemical1748392chemical
coccal9310222co_ccal
codicil1246812codicil
coital84117052co_ital
comal95125132com__al
comic114721812comic__
comically18310512comically
comics124015562comic_s
comitial1248692comitial
cortical12412212cortical
cotidal1038452cotidal
cubical1338462cubical
cynical1437872cynical
domicil1246432domicil
gnomical1346682gnomical
iconical1248202iconical
logical1038512logical
mimical1339232mimical
nodical1049862nodical
nominal92712372nominal
somital939402somital
topical1139952topical
toxical1637642toxical
vomica1336382vomica_
vomicae1445302vomicae
acromial1248463acromi_al
acronical1347833acronical
admiral1046363admiral
alogical1147763alogical
apical10913903_apical
biotical1248863biotical
caecal103713733c_aecal
cambial134010763cambial
cameral11311283cameral
camisa103114323camisa_
camisas113411923camisas
canonical1347213canonical
capital112311523capital
caracal11312513caracal
carinal94318233carinal
cecal94619113c__ecal
cercal10314123c_ercal
cervical1546853cervical
chemicals1845603chemicals
chica125818263c_hica_
chicas135916473c_hicas
chiral114614413c_hiral
chital114313883c_hital
chorial124214143chori_al
cicala10310053c__icala
cicale10314503c__icale
cimices13279803cimices
clerical1248233clerical
clinal8311553c_linal
clinical1247023clinical
cloacal1135163cloacal
coaeval1245183coaeval
coal66939253co___al
coastal9411043coastal
coaxal15387303co_axal
coaxial16157003coaxial
cobia94117513cobi_a_
cobias104014993cobi_as
coca88030643co__ca_
cocas95926573co__cas
codices12512583codices
codicils1346043codicils
coequal1844933coequal
coeval1138893co_eval
coil66439653co_i__l
colic95726173colic__
colicin11313743colicin
colicky1835783colicky
colics104219903colic_s
coma87134853com__a_
comae97128423com__ae
comas95833003com__as
combat12316753com_bat
comicality1946133comicality
coming114225453comi_ng
comingle1336053comingle
comings124013533comings
comitia1139723comitia
comity13312713comi_ty
comix163513203comi__x
comma114514793com_ma_
commas124814573com_mas
committal1543723committal
communal1446353communal
compact153712213compact
compas125817063com_pas
compel124412893com_pel
comprisal1544513comprisal
conceal113313013conceal
conchal144211583conchal
confocal1546303confocal
congeal104011683congeal
conic95329793conic__
conically16312813conically
conics103920593conic_s
conidial1159503conidial
conoidal1149003conoidal
cooncan1147233cooncan
copal95621783co__pal
copycat1647593copycat
coral76033453co__ral
cordial10312943cordial
coria75828323cori_a_
corneal94414503corneal
cornual94210173cornual
coronal94115763coronal
corral83616253co_rral
corrival1346153corrival
coryzal2154823coryzal
cosmic12410343cosmic__
cosmically1948013cosmically
costal85419513co_stal
council1137473council
coxal146116673co__xal
criminal1248303criminal
critical12310263critical
crucial1157893crucial
cubital1137103cubital
curial84019153curi_al
cyclical1445653cyclical
cymbal15236913cym_bal
domal85619203dom__al
domic104317243domic__
domically1749093domically
domicile1346083domicile
domicils1345073domicils
dominical1446003dominical
ecocidal1354963ecocidal
economical1645963economical
epical10413393_epical
erotical101911983erotical
ethical1238443ethical
finical1239693finical
focal104917673fo__cal
formica1436443formica_
formicas1546003formicas
fornical1347793fornical
geminal10109903geminal
gomeral1038833gomeral
helical12311153helical
homicidal1743863homicidal
inimical1247313inimical
ironical1049963ironical
jovial1636543jovi_al
laical8312323_laical
laminal94113633laminal
lexical1637363lexical
liminal93810673liminal
local74820273lo__cal
lorica8310443lorica_
loricae938253loricae
luminal93711003luminal
lyrical1236493lyrical
magical1239783magical
medical12312513medical
metical11315363metical
mica86428253__mica_
micas96823053__micas
modica11310063modica_
musical1139553musical
nomina83113683nomina_
nominals10278613nominals
obconical1544173obconical
ocicat101412813_ocicat
ogival1035873_ogival
oomiac1037063oomi_ac
oomiack1544223oomiack
oomiacs1135683oomiacs
oomiak1235353oomi_ak
optical1149863optical
pemican1348153pemican
pical95524373__pical
plical10411683_plical
poetical12311533poetical
polemical1547343polemical
pollical1247953pollical
radical103312793radical
rhombical1852853rhombical
ruminal9289993ruminal
scenical1247133scenical
seminal91213403seminal
social8813333soci_al
stoical9310273stoical
tical76021493__tical
tombal102311023tom_bal
tomcat101013453tom_cat
tropical1248733tropical
typical1436343typical
vatical1239983vatical
vesical12159813vesical
viminal12288823viminal
vocal104715643vo__cal
vortical1348863vortical
zodiacal2042243zodiacal
zooidal1745083zooidal

Search took 8 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.1561145455.1
2DLD Change Limit1340272056.79619721.5
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.03225411.1
 
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.