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

232 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
apicals115992(None) 
apical10913901apical_
animals94111702animals
apically1539832apically
apices104916262apic_es
apiculi1145112apiculi
apiculus1245412apiculus
appals104812942ap_pals
appeals11378672appeals
capitals12209442capitals
epical10413392epical_
pascals11610012pascals
pibals103813082_pibals
pical95524372_pical_
picas94626522_pica_s
piculs103511752_piculs
pipals104213642_pipals
radicals112610152radicals
spicas104715822spica_s
spinals93911862spinals
spirals93212512spirals
spitals93011592spitals
ticals83214712_ticals
aals49941143a___als
abacas104414723abaca_s
abapical1444943abapical_
abigails1143333abigails
acetals93411353acetals
acicula11228133acicula
aciculas12228563aciculas
acyls104211523a__cyls
admirals1144353admirals
aecial84817313aecial_
aerials74017553aerials
agitas7310593agita_s
ails45654713a_i__ls
ajivas1655133ajiva_s
alias55834603ali_a_s
alidads936293alidads
aliyahs13395323aliyahs
aliyas93911803aliya_s
alpacas1137073alpaca_s
amias75831473ami_a_s
amicable1438433amicable
amicably1746333amicably
amices105018013amic_es
amicus103810003amic_us
amidols10457563amidols
amigas95912173amiga_s
anils56326723ani__ls
animal85016253animal_
animas84418723anima_s
annals66415923a_nnals
anneals7449943anneals
annuals7388193annuals
apaches143411833apaches
apetaly1237253apetaly
apian75018333api_a_n
apiary113910383api_ary
apishly1535663apishly
apneal83411123apneal_
apneas83211383apnea_s
apocarp1355133apocarp
apocarps1474423apocarps
apodal9289833apodal_
appal95315223ap_pal_
appall10379743ap_pall
appalls11337743appalls
appeal103911613appeal_
appears11308953appears
appels104312793ap_pels
apricots1275393apricots
apsidal1046703apsidal_
arecas84817443areca_s
argals75517713a_rgals
arias55438023ari_a_s
ariels65119373ari_els
arils58732203ari__ls
arnicas939543arnica_s
arrivals1145933arrivals
ashcans1235183ashcans
asocials1075683asocials
aspics104211563aspic__s
astrals75515243astrals
atabals938413atabals
atypical1544683atypical_
avians93711563avi_ans
avowals1335013avowals
axial124515193axi_al_
axillas14278963axillas
axils127217503axi__ls
bridals1038623bridals
capias10318353capi_a_s
capital112311523capital_
capitols12247333capitols
caporals1238923caporals
caracals12310743caracals
chicas135916473chica_s
cicala10310053_cicala
cicalas1139303_cicalas
cicale10314503_cicale
decals93717713_decals
dials64925343_di_als
epically15310583epically
epicalyx2242303epicalyx
epicarp1376073epicarp
epicarps1444783epicarps
epics95014283epic__s
epinaos936283epinaos
ericas8315463erica_s
espials937093espi_als
ethicals1345533ethicals
facials123310743faci_als
faucals12326563faucals
fecials123510333fecials
finals94316163_finals
fiscals1238003fiscals
gavials1136603gavi_als
haptical1547343haptical_
ipecacs1354503ipecacs
jacals1539873_jacals
labials9299873labi_als
laical8312323laical_
laminals10339303laminals
lanitals837723lanitals
locals83714503_locals
magical1239783magical_
maximals19325223maximals
medicals1349363medicals
mescals112911553mescals
meticals12310763meticals
mezcals20246533mezcals
micas96823053_mica_s
musicals1247093musicals
nicads938333_nicads
nicols8810243_nicols
ocicats11137413ocicats
opals75718353op__als
optical1149863optical_
pacas96029403_paca_s
pails75833063pai__ls
paisans93614753paisans
paisas84317493paisa_s
pals66951353_p__als
papricas1447053paprica_s
parcels113712663parcels
parrals94414573parrals
pascal10812373pascal_
paschals1566473paschals
peals75235493_p_eals
pecans101515833_pecans
pedals94316033_pedals
petals84719813_petals
phials1158873_phials
pial65636703_pi_al_
pians75126963_pi_ans
pias66542553_pi_a_s
pibal95217323_pibal_
pica85831493_pica__
picara10311903_picara
picaras11311283_picaras
picaro10311323_picaro
picaros11310893_picaros
pickle144215653_pickle
pickles153215443_pickles
picks135226143_pic_ks
picots104616443_picots
pics85633913_pic__s
picul95015363_picul_
pikas114218093_pika_s
pilafs113511023_pilafs
pilaus84114133_pilaus
pilaws11399433_pilaws
pills74130973_pi_lls
pimas94725103_pima_s
pinas75434453_pina_s
pineals93212843_pineals
pipal95118353_pipal_
pitas77427673_pita_s
pixels15478533_pixels
plical10411683plical_
radials83614633radi_als
radical103312793radical_
radicels11297183radicels
rascals959663rascals
rials55026673_ri_als
rivals94213183_rivals
riyals94111083_riyals
sahiwals1443643sahiwals
sials54227243_si_als
sisals63013573_sisals
socials999633socials
specials1238033specials
spica94717943spica__
spicae104313703spica_e
spicate113214193spicate
spicers113815553spicers
spices104326033spic_es
spicily1438653spicily
spicks144814993spic_ks
spics94123243spic__s
spicula11259293spicula
spicule11269933spicule
spicules12219803spicules
spiels85317953spi_els
spills84717463spi_lls
spinal84915313spinal_
spinels94512443spinels
spiral83715343spiral_
spital83813873spital_
tapiocas1244783tapioca_s
taxicabs1942223taxicabs
tical76021493_tical_
tincals93610643tincals
tipcats1137103tipcats
topical1139953topical_
trials64319883tri_als
tribals9610753tribals
tropicals1345613tropicals
typical1436343typical_
uncials92510523uncials
upscale11136323upscale
upscales12155993upscales
urials64415193uri_als
urinals7610253urinals
vatical1239983vatical_
vials85822383_vi_als
viaticals1444073viaticals
vicars11712263_vicars
vinals94716483_vinals
vitals94514303_vitals
vocals113811583_vocals

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 Limit1340272326.96619240.2
3Display Results2322320.0802900.0
 (SQL Overall)1786912327.20224811.3
 
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.