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

179 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
apiaries1031272(None) 
aviaries1139781aviaries
ambaries123312382ambaries
angaries9314392angaries
aperies9423202ap_eries
apiarian1048322apiarian
apiarians1146652apiarians
apiarist10412052apiarist
apiarists1147882apiarists
diaries83321952_diaries
friaries11310082friaries
laniaries9411212laniaries
lapidaries1345062lapidaries
paries84742512_p_aries
topiaries1147112topiaries
abbacies1445483abbacies
acarids105312243a_carids
acarines10314343a_carines
actuaries1147563actuaries
aeries64737783a__eries
affaires1444303affaires
agarics10319943a_garics
airier64619363a_i_rier
airiest74221013a_i_riest
aliases7914493alia_ses
alibies9313323ali_bies
alizarines1944663alizarines
alizarins1845893alizarins
alkalies12158543alkalies
ambaris113112163ambari_s
amberies122514683amberies
ambries111614553a_mbries
amirates101114793amirates
amities9317383ami_ties
angarias9310553angarias
animacies1348593animacies
antiarins9413893antiarins
anticaries12412473anticaries
apaches143411833ap_aches
apathies1339003apathies
apatites10311293ap_atites
apetalies1148003apetalies
aphagias14237343aphagias
aphanites1448263aphanites
aphasias132710433aphasias
aphasics15257233aphasics
aphorise1339983aphorise
aphorises14310003aphorises
aphorizes2348013aphorizes
apiary113910383apiar__y
apices104916263api__ces
apimanias1345113apimanias
aplasias10279233aplasias
apoapses1244713apoapses
apocarpies1653523apocarpies
apogamies1445323apogamies
aporias9315153ap_orias
apparats1287093apparats
apparel1146003appar_el
apparels1245123apparels
applies11311213ap_plies
appraise1247703appraise
appraises1347423appraises
apprise11310193ap_prise
apprises12310963ap_prises
apprizes2137793ap_prizes
apraxias1746333apraxias
apres75426403ap__r_es
apyrases1337243apyrases
armories10313653armories
arteries8321483arteries
ascarides12346953ascarides
ascarids11438503ascarids
ascaris93613323ascari_s
aspirates1139613aspirates
aspires9612043aspi_r_es
aspirins1037733aspi_rins
ataxies142410013a_taxies
auguries947933auguries
autarkies1344773autarkies
avarices1337183a_varices
avianizes2145553avianizes
aviarist11410113aviarist
aviarists1246613aviarists
aviates10313063avia_tes
aviatrices1543163aviatrices
aviatrixes2042093aviatrixes
axillaries1744873axillaries
bialies93618413_bialies
binaries10314183binaries
calvaries1449803calvaries
canaries10318943canaries
capiases1239253capia_ses
capillaries1554453capillaries
caries85147623__caries
caviares1337993caviar_es
chivaries1757433chivaries
claries93422203_claries
covaries13413253covaries
dairies84217733dai_ries
dataries9314033dataries
dearies83526273_dearies
drearies92313413drearies
epitaxies1845193epitaxies
expiries1747753expi_ries
fairies103516043fai_ries
jaggaries18135743jaggaries
janisaries1744783janisaries
janizaries2643503janizaries
japeries17311463jap_eries
naperies10313903nap_eries
notaries8314933notaries
opiates9312143opia_tes
ostiaries948803ostiaries
ovaries10312653_ovaries
panfries13149203panfries
pantries101817393pantries
papacies1439473papacies
papistries1445193papistries
pares77164483_p_ar_es
parges94529543_p_arges
paris75145943_p_ari_s
parises94827183_p_arises
parles86334403_p_arles
parries93925843_parries
parses85534703_p_arses
parties93230863_p_arties
pastries101517423pastries
peavies122213403_peavies
peeries93623023_peeries
perries93226603_perries
piaffes15115053_piaffes
picrites121811083_picrites
pierces113411193_pierces
pieties9419223_pieties
piggies113813483_piggies
pigmies122610993_pigmies
pineries102419083_pineries
pinkies133818263_pinkies
pinnies93318443_pinnies
piracies12312643_piracies
pirates93020333_pirates
piscaries13410073_piscaries
pities83828083_pi_ties
pixies154915513_pi_xies
plagiaries13146103plagiaries
platies93722543_platies
prairies10411453_prairies
pries74339533_p__ries
primaries13410833primaries
priories10312453priories
quinaries1857873quinaries
rapparees1343953rapparees
rosaries8312783rosaries
rotaries8315693rotaries
salaries8319573salaries
sanitaries1049913sanitaries
spares84834553sp_ar_es
sparges104016343sp_arges
sparids103512123sp_arids
spavies123012943sp_avies
spiceries1349313spiceries
spiffies16277993spiffies
spinnies103210543spinnies
spires84628113spi_r_es
spirier93214073spi_rier
spiriest102513453spi_riest
spirits94112623spi_rits
spurries102311323spurries
sudaries9312753sudaries
updries10209083up_dries
urinaries949203urinaries
vagaries12310293vagaries
varies94330873__varies
vespiaries1543583vespiaries
vivaries1439263vivaries
votaries11312013votaries
wearies103020223_wearies
whirries14136693whirries

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621796.34623032.1
3Display Results1791790.0602983.3
 (SQL Overall)1786911796.82626178.0
 
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.