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

373 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
apsides10391130(None) 
aphides134711201aphides
asides75118871a_sides
upsides10319631upsides
abides94719892a_bides
aides65336602a__ides
alsikes1137262alsikes
amides95722662a_mides
aphids125110842aphid_s
apices104916262ap_ices
aplites9314932aplites
apses76823912aps__es
apsidal1046702apsidal
apsis75718292apsi__s
arsines73518812arsines
aside65122082a_side_
aspires9612042aspires
aspises9611642aspises
assizes1638452assizes
azides165113802a_zides
besides104814532besides
capsids1239332capsid_s
capsizes2147202capsizes
daysides1335962daysides
depsides1238502depsides
farsides1237992farsides
insides8512652insides
lapides103012042lap_ides
prides94324182_prides
raphides14188392raphides
resides84523282resides
sides65838362__sides
topsides1137202topsides
upside9289802upside_
upsizes18297162upsizes
waysides1544452waysides
abide86223713a_bide_
abided105313313a_bided
abider95314463a_bider
abiders104011083a_biders
abodes94417513a_bodes
abrades10312073abrades
abridges1245303abridges
abscises1246233abscises
accedes1237713accedes
accidies1338043accidies
acids87121003a_cid_s
acnodes1037823acnodes
acrider1038623acrider
acridest1138143acridest
actives12311523actives
admires1038663admires
admixes1765963admixes
advices13136933advices
advises11138973advises
aedes64625143a__edes
aediles83413903aediles
aegises8311373aegises
aeries64737783aeri_es
affines1339483affines
affixes2035503affixes
aggies83515513aggi_es
agnizes17328843agnizes
aide56044993a__ide_
aided75828933a__ided
aider65431133a__ider
aiders74524633a__iders
aids57846353a__id_s
aikidos1253883aikidos
aisles64721143ais_les
albites9313203albites
alcades101011473alcades
alcaides11117673alcaides
alcids94812293alcid_s
alines65735223a_lines
alkies104518093alki_es
alkines114415733alkines
allies63827673alli_es
alludes83610333alludes
almudes10418263almudes
alpines94016193alpines
alsike1047913alsike_
amices105018013a_mices
amide86128483a_mide_
amids85627513a_mid_s
amies76837693a_mi_es
amines84727983a_mines
ammines11312673ammines
amosites10311233amosites
animes84719593a_nimes
anises64826693a_nises
anodes74418753a_nodes
apaches143411833apaches
apatites10311293apatites
aperies9423203aperies
apes66047433ap___es
apexes1539133ap_exes
apheses12610703apheses
aphid115515393aphid__
aphis105917133aphi__s
aplite8316393aplite_
apoapsides1542373apoapsides
apods86316343ap_od_s
apogees1037103apogees
apomixes1934853apomixes
apostles1037753apostles
apples104315763ap_ples
applies11311213applies
apposes11511473apposes
apprises12310963apprises
apprizes2137793apprizes
apres75426403ap__res
apse67725383aps__e_
aptitudes12156183aptitudes
arcades101113193arcades
arcsines104010343arcsines
arider74717743a_rider
aridest8316143a_ridest
arises65233803a_rises
armies85123693armi_es
aroids75118223aroid_s
arrises71617583arrises
arrives101311513arrives
arsenides1095613arsenides
arses55733873ars__es
arsine64021043arsine_
arsis55722423arsi__s
ascites9312603ascites
asdics9439863a_sdics
ashes86230613a_s_hes
aspics104211563aspi_cs
aspire8612123aspire_
aspired1068173aspired
aspirer967903aspirer
aspirers1066493aspirers
aspis74618143aspi__s
asses55629283a_s_ses
assigns836193assigns
assists738473assists
assize1538633assize_
assumes967163assumes
assures7611403assures
attires72312953attires
aubades1038753aubades
audiles83112613audiles
augites8312183augites
auspices1236443auspices
avoided1235553avoided
avoider1155813avoider
avoiders1254793avoiders
avoids104410203avoid_s
axises134413993a_xises
axites134913833a_xites
axseeds1533393axseeds
azide155617163a_zide_
azines155517073a_zines
backsides1887693backsides
banksides16104853banksides
baptises1238923baptises
baptizes2136843baptizes
bedsides1246533bedsides
beside95114613beside_
betides104915263betides
bides85536773__bides
bolides10515073bolides
borides10515153borides
brides94423513_brides
busies85525263busi_es
campsites1546473campsites
capizes20410373cap_izes
caprices1439893caprices
capsid11312413capsid__
capsidal1345623capsidal
capsize2037623capsize_
capsized2255493capsized
capsules1236623capsules
captives1538623captives
carbides133111693carbides
cassines103116613cassines
cassises103811743cassises
chides124620473_chides
cosies84932153cosi_es
cosines94122673cosines
cuspides13306943cuspides
daisies84217093daisi_es
dapsones1138383dapsones
dassies84418663dassi_es
dayside1236173dayside_
decides114217653decides
depside1138403depside_
derides93420853derides
desires81316133desires
diapsids1244753diapsid_s
diopsides1345283diopsides
dipsades1246493dipsades
divides123211453divides
easies64126633easi_es
elides74420693_elides
ensiles72714833ensiles
eosines73718293eosines
episodes1145913episodes
epodes94315563ep_odes
epoxides1844863epoxides
espies83716803espi_es
excides1738343excides
falsies103515013falsi_es
farside1138603farside_
gaposises1245523gaposises
gipsies1039903gipsi_es
glides84518863_glides
grides84422363_grides
guides84118283_guides
gypsies1335953gypsi_es
hagrides1337623hagrides
halides113416663halides
hapkidos1842713hapkidos
haplites1339993haplites
hayrides1536883hayrides
hides95129423__hides
ides57734233___ides
imides94515343_imides
inside7613453inside_
insider849733insider
insiders947763insiders
iodides93811613iodides
irides74519123_irides
jassids1586143jassid_s
lakesides1444093lakesides
landsides11116743landsides
lapises93513463lap_ises
lapses85217693laps__es
lassies74420103lassi_es
lipides103810623lipides
lopsided1244253lopsided
lysines10369093lysines
mysids1246563mysid_s
nappies114613393nappi_es
nearsides1044513nearsides
nides65229133__nides
offsides1543393offsides
onside7511803onside_
ophites12310103ophites
opines84820703op_ines
opsins8411713opsi_ns
optimes1148473optimes
oreides8312023oreides
oroides8311973oroides
outsides92513233outsides
oxides14109693_oxides
paddies113715723paddies
palsies94420273palsi_es
pandies104224503pandies
pansies94521983pansi_es
pappies103214823pappi_es
parades104121463parades
paries84742513pari_es
parises94827183parises
pases75346503pas__es
pashes115828393pas_hes
passades1139203passades
passes86030473pas_ses
passives13228823passives
pastes85233913pas_tes
pasties94529813pasties
pastimes123611903pastimes
pastises103616053pastises
patines95225763patines
patsies93919483patsi_es
pavises125315493pavises
pedes85327283_p_edes
peises84125043_peises
pepsines1239883pepsines
peptides132610263peptides
pesades10310903pesades
phizes20389133_phizes
pies66949603_p_i_es
pikes115031033_p_ikes
piles74742613_p_iles
pines76048863_p_ines
pipes96030143_p_ipes
pishes114722103_pishes
pisses84525083_pisses
pistes85325633_pistes
pixes144323173_p_ixes
plies74526513_pli_es
poises84226543_poises
popsies112816463popsi_es
posies84431433posi_es
presides11414913presides
prices104524543_prices
pride84724733_pride_
prided103618033_prided
pries74339533_pri_es
primes104225263_primes
prises84133173_prises
prizes173819813_prizes
prudes94215443_prudes
psis68120343_psi__s
pyxides2034423pyxides
quaysides2243283quaysides
rachides141511223rachides
raphide13138073raphide_
rapider1067903rap_ider
rapidest1138543rap_idest
rapids94913893rap_id_s
rapines95120863rap_ines
rawhides15145543rawhides
reside74224933reside_
resided95217703resided
resider84615803resider
residers93311883residers
resids74219153resid_s
residues9338813residues
resiles74026543resiles
resites74027793resites
resizes164216843resizes
rhapsodes1543183rhapsodes
rides66140813__rides
riptides1136413riptides
roadsides1144463roadsides
sades65239893__sades
sassies74719263sassi_es
seasides938743seasides
shipsides1544883shipsides
sices75637273__sices
side55444483__side_
sided74825953__sided
sidles74721153__sidles
sikes96236083__sikes
sines55954823__sines
sipes76036953__sipes
sires55945373__sires
sises55233833__sises
sites56045433__sites
sixes124526363__sixes
sizes146727763__sizes
slides73922183_slides
spades94222583sp_ades
speises93813933speises
spices104326033sp_ices
spider94516803sp_ider
spiders103914413sp_iders
spies76037623sp_i_es
spikes124520713sp_ikes
spiles84227913sp_iles
spines85132033sp_ines
spires84628113sp_ires
spites84127333sp_ites
splices113914383splices
splines94718893splines
spodes94817433sp_odes
sprites94220333sprites
strides84520393strides
subsides11410823subsides
tansies74521243tansi_es
tapises92914013tap_ises
tassies74918933tassi_es
tides64830153__tides
topside1037733topside_
topsider1144503topsider
topsiders1243023topsiders
tsades74310993_tsades
updives1334713updives
uppiles11208263uppiles
uprises92012733uprises
upsize17267303upsize_
upsized19246253upsized
uptimes1177553uptimes
ureides8311103ureides
ursids737823ursid_s
wayside1435183wayside_
weaksides1742473weaksides
wides94832823__wides

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.1401276364.3
2DLD Change Limit1340273736.75019855.9
3Display Results3733730.1262960.3
 (SQL Overall)1786913737.01625469.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.