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

533 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
aspics10421156(None) 
asdics9439861asdics
aspic95114731aspic_
aspis74618141aspi_s
spics94123241_spics
antics84621452antics
apices104916262a_pices
apsis75718292apsi_s
asdic83814092asdic_
aspect10612822aspect
aspects1146742aspects
aspens85013352aspens
aspers86220312aspers
aspire8612122aspire
aspires9612042aspires
aspises9611642aspises
aspish114810332aspish
asps65622092asp__s
attics84413282attics
auspice1136522auspice
auspices1236442auspices
basics104915122bas_ics
epics95014282_epics
espies83716802espies
mastics112614782mastics
osmics1036462osmics
pics85633912__pics
sics65234092_s_ics
specs96916672_specs
spic85227432_spic_
spica94717942_spica
spicas104715822_spicas
spice95528812_spice
spices104326032_spices
spick134519072_spick
spicks144814992_spicks
spicy125417712_spicy
spies76037622_spies
spiks114117472_spiks
spins75327982_spins
spits74429552_spits
spivs105114242_spivs
topics104714582topics
aaliis6312903aaliis
ablins8316193ablins
abris75722603abri_s
abseils935973abseils
acids87121003a_cids
acmic11312333acmic_
actins86321103actins
addict10711203addict
addicts1176013addicts
adios65822863a_dios
adipic1137263adipic_
adits66523713a_dits
admits9411413admits
advice12107883advice
advices13136933advices
aegis6316783aegi_s
aeries64737783aeries
afrits9311903afrits
agarics10319943agarics
aggies83515513aggies
agios65919863a_gios
agrias74315393agrias
ahis76135383a_hi_s
aids57846363a__ids
ails45654713a__ils
aims67738183a__ims
ains46158883a__ins
airs46447423a__irs
ais39083573a__i_s
aits46355533a__its
alcaics1137023alcaics
alcids94812293alcids
alecs76620733a_lecs
algins74816433algins
alias55834603a_lias
alifs86121263a_lifs
alkies104518093alkies
allies63827673allies
allspice1243343allspice
allspices1343093allspices
alnico877943alnico
alnicos985533alnicos
aloins65022203aloins
alpaca1047383alpaca
alpacas1137073alpacas
alphas1139513alphas
alpine84417373alpine
alpines94016193alpines
alps65529243alp__s
ambits103713413ambits
amias75831473a_mias
amice96122873a_mice
amices105018013a_mices
amici94217393a_mici
amicus103810003a_micus
amids85627513a_mids
amies76837693a_mies
amins75534323a_mins
amirs75924923a_mirs
amis66445323a_mi_s
amiss75823073a_miss
amnic95516243amnic_
amnios84912523amnios
amping114317573amping
amps86230343amp__s
ampuls1098893ampuls
anils56326723a_nils
anis45746463a_ni_s
anopias92412483anopias
antic75728863antic_
antick124814583antick
anticks134612253anticks
antis55033313anti_s
anvils9219713anvils
apace94718383a_pace
apers76629133a_pers
apes66047433a_p_es
aphids125110843aphids
aphis105917133a_phis
apian75018333a_pian
apical10913903a_pical
apicals1159923a_picals
apiece10510083a_piece
aping87327233a_ping
apish105116633a_pish
apods86316343a_pods
apos65433823a_p_os
appals104812943appals
appels104312793appels
apples104315763apples
applies11311223applies
apps86319693a_p_ps
apres75426403a_pres
apses76823913a_pses
apsides103911303apsides
arcs67834783a__rcs
arctics1138953arctics
areic73219393areic_
argils75213623argils
arias55438023a_rias
arils58732203a_rils
armies85123693armies
armpits1157133armpits
arnica8310443arnica
arnicas939543arnicas
aroids75118223aroids
arpens84814823arpens
arris56824683arri_s
arsenics1056763arsenics
arshins10312573arshins
arsis55722423arsi_s
aruspices1343353aruspices
asanas6514113asanas
ascetics1247073ascetics
asci66519143as__ci
ascites9312603ascites
ascots85312513ascots
ascus75013583as_cus
asepses946363asepses
asepsis985903asepsis
aseptic1137373aseptic_
ashes86230613as_hes
ashier94714833ashier
ashiest10313963ashiest
ashing107824093ashing
aside65122083as_ide
asides75118873asides
askers105915403askers
asking116017233asking
askings12519173askings
askos95011773as_kos
asks85721213as__ks
asp57235343asp___
aspen75216093asp_en
asper75520433asp_er
asperse94210663asperse
aspired1068173aspired
aspirer967903aspirer
aspirers1066493aspirers
aspirin937823aspirin
aspirins1037733aspirins
ass37844063as___s
assails769093assails
assais6711963assais
assays977903assays
asses55629283as_ses
assess65710463assess
assets65617663assets
assign736783assign
assigns836193assigns
assist6314603assist
assists738473assists
assize1538633assize
assizes1638453assizes
assoils776663assoils
asters65631603asters
astir55517093asti_r
astrict9614793astrict
astricts1049463astricts
aswirl935093aswirl
ataxics16196643ataxics
atomics113110853atomics
atonics93613713atonics
atopic103514143atopic_
atopies92816433atopies
attic75618353attic_
atypic13337653atypic_
audios72312283audios
audits72814113audits
aulic74420243aulic_
auric74521743auric_
auris55331533auri_s
auxins13129813auxins
avails939693avails
avoids104410203avoids
awaits96411953awaits
axils127217503a_xils
axis116127913a_xi_s
ayins85321613a_yins
azoic162912063azoic_
basic96220523bas_ic_
basils85717473bas_ils
basins85722763bas_ins
basis75429863bas_i_s
biopics13318543biopics
bustics11810883bustics
calpacs133110343calpacs
capias10318353capias
capsids1239333capsids
caseic103212373caseic_
caseins93115053caseins
cassias93514343cassias
cassis84818853cassi_s
caustics1237483caustics
chics123920943_chics
civics13397823civics
classics12418873classics
clastics122811413clastics
colics104219903colics
comics124015563comics
conics103920593conics
copies104130303copies
cubics123810163cubics
cupids11369193cupids
cuspids12427113cuspids
cuspis105010703cuspi_s
cynics13377363cynics
darics94314113darics
dashis104414393dashi_s
dassies84418663dassies
depict113514793depict
depicts12358463depicts
easies64126633eas_ies
elastics102710883elastics
epic86921303_epic_
espial839543espial
espials937093espials
espied9359773espied
esprits938393esprits
ethics11169283ethics
fabrics1436093fabrics
fanfics1535173fanfics
fascias1258413fascias
flics105418363_flics
fustics1279593fustics
garlics1038013garlics
gaskins123510773gaskins
gaspers105014133gaspers
gasping113714363gasping
gasps85415483gasp__s
harpies123818323harpies
harpins123615703harpins
hasping134414903hasping
hasps105114643hasp__s
hatpins123410643hatpins
hospice14117063hospice
hospices1587633hospices
iambics13425643iambics
impis96213853impi_s
ionics84214483ionics
jasmins1637083jasmins
jaspers164310463jaspers
jassids1586143jassids
kalpacs15327133kalpacs
kepis115313363kepi_s
laics76419253_laics
lapins84520683lapins
lapis76223153lapi_s
lashins103915153lashins
lassies74420103lassies
lassis65216703lassi_s
lipids94310923lipids
lipins85016883lipins
logics95711123logics
lupins84514463lupins
lyrics11357943lyrics
magics115311613magics
magpies12310363magpies
manics103919933manics
mashies12318253mashies
masjids17175403masjids
massifs1237743massifs
mastic103119173mastic_
medics114115353medics
mics87435153__mics
mimics1289363mimics
mosaics1138073mosaics
musics103911783musics
mystics14279103mystics
nappies114613403nappies
nastic82915973nastic_
nasties73520493nasties
oasis56422553oas_i_s
opsins8411713opsins
optics102810183optics
orpins83614163orpins
osmic939913osmic_
pacs85842183__pacs
panics103815363panics
pappies103214833pappies
pasties94529813pasties
pastils94416173pastils
pastis84924323pasti_s
pecs84634103__pecs
peptics132610243peptics
pias66542553__pias
pic76046823__pic_
pica85831493__pica
picas94626523__picas
pice84641093__pice
pick125933813__pick
picks135226143__picks
pies66949603__pies
pigs76634223__pigs
pins65558453__pins
pipits104713063pipits
pips85837133__pips
pis56362033__pi_s
piss65033333__piss
pits66348743__pits
plastics122412333plastics
psis68120343ps_i_s
pupils10389913pupils
rapids94913893rapids
raspers94415923raspers
raspier93110643raspier
raspiest10311283raspiest
rasping104316253rasping
raspings11337853raspings
raspish1298103raspish
rasps74316663rasp__s
relics84517903relics
repins84924313repins
rustics9810733rustics
sabins85521983sabins
sabirs85414633sabirs
sacs65739073_s_acs
sadis64930853sadi_s
sahibs1137083sahibs
saice75424053_saice
saices84221803_saices
saids65328853_saids
sails55738103_sails
sains55639973_sains
sakis95323673saki_s
salic73424713salic_
salpids1038193salpids
sanies63031953sanies
sapid84720933sapi_d
sapiens9310173sapiens
sapors84118813sapors
sapphics1743423sapphics
saps65346373sap__s
sarins63932623sarins
saris54544953sari_s
sasins64923103sasins
sassies74719263sassies
satins64930483satins
satis55633683sati_s
savins93923133savins
sayids104310973sayids
secs65033893_s_ecs
seifs85019333_seifs
seis45542393_sei_s
sepias83616103sepias
sepic94617053sepic_
septics112810433septics
shies86136553_shies
shims104422553_shims
shins85131043_shins
ships105123773_ships
shits84731173_shits
shivs115018803_shivs
sibs65933543_s_ibs
sic55847873_s_ic_
sice65545593_s_ice
sices75637273_s_ices
sick106435573_s_ick
sicks115127623_s_icks
sims65737173_s_ims
sins46755273_s_ins
sipes76036953_sipes
sips65740103_s_ips
sirs44338333_s_irs
sis37360543_s_i_s
sits45050203_s_its
skids104615333_skids
skies95026833_skies
skims114517193_skims
skins94723463_skins
skips115616603_skips
skis84825293_ski_s
skits94721863_skits
slice74925823_slice
slices84022853_slices
slick115520523_slick
slicks124816113_slicks
slims75423653_slims
slips76023723_slips
slits56128853_slits
snibs75613763_snibs
snick114416013_snick
snicks124312473_snicks
snips75818013_snips
snits54124833_snits
soils55327983_soils
sonics84315633sonics
space95325673_space
spaces104722633_spaces
spacy125415623_spacy
spaes76029973_spaes
spails84817823_spails
spaits85017473_spaits
spams94922193_spams
spans74528733_spans
spars75431543_spars
spas67036723_sp_as
spastics1237503spastics
spats75031383_spats
spays105520513_spays
spec85821973_spec_
speck135115653_speck
specks144312703_specks
speils84116223_speils
speirs85013233_speirs
speiss84311643_speiss
spews105015923_spews
spicae104313703_spicae
spiced115218313_spiced
spicer104719313_spicer
spicers113815553_spicers
spicey134414233_spicey
spied85427713_spied
spiel74623913_spiel
spiels85317953_spiels
spier75728033_spier
spiers84421743_spiers
spiff133616403_spiff
spiffs14328473_spiffs
spik105419713_spi_k
spike114922843_spike
spikes124520713_spikes
spiky146014113_spiky
spile75230083_spile
spiles84227913_spiles
spill74821163_spill
spills84717463_spills
spilt75532223_spilt
spin66231303_spi_n
spine76534423_spine
spines85132033_spines
spiny104921303_spiny
spire75828693_spire
spires84628113_spires
spirt75032953_spirt
spirts85317133_spirts
spiry105017353_spiry
spit65545083_spi_t
spite75430663_spite
spites84127333_spites
spitz166017973_spitz
spiv95917793_spi_v
splice104915103_splice
splices113914383_splices
splits85416413_splits
spoils84614533_spoils
spots74424113_spots
sprigs94814773_sprigs
sprits85122533_sprits
spuds85113673_spuds
spues75025383_spues
spurs74621523_spurs
sris45434153_sri_s
stich104117923_stich
stichs114511653_stichs
stick115121563_stick
sticks125118613_sticks
sties55132983_sties
stirs55921623_stirs
stoics8311113stoics
suits55028053_suits
swigs96213663_swigs
swims105514143_swims
swiss86712903_swiss
syncs104610173_syncs
tactics1149323tactics
tapirs84113173tapirs
tapis75028863tapi_s
tassies74918933tassies
tawpies12309873tawpies
tics65729633__tics
tipis76019923tipi_s
tonics83617863tonics
topic95721503topic_
topis76025833topi_s
torics85118353torics
toxics153910203toxics
tropics113610653tropics
tunics83811263tunics
tupiks1235493tupiks
typic124511963typic_
unpick1446903unpick
unpicks1545183unpicks
unpins82312383unpins
vespids1334613vespids
waspier12259053waspier
waspiest1338823waspiest
waspily1535513waspily
waspish1586923waspish
wasps106714693wasp__s

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 Filter1786911127160.406440125.6
2DLD Change Limit1127165335.70319764.3
3Display Results5335330.1563416.7
 (SQL Overall)1786915336.26528522.1
 
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.