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

171 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
friaries1131008(None) 
apiaries10312732apiaries
aviaries1139782aviaries
diaries83321952_diaries
drearies92313412drearies
fairies103516042fai_ries
friars93812092friar__s
frizzies19315932frizzies
prairies10411452prairies
primaries13410832primaries
priories10312452priories
urinaries949202urinaries
ambaries123312383ambaries
angaries9314393angaries
armories10313653armories
arteries8321483arteries
bialies93618413_bialies
binaries10314183binaries
braxies16711463br_axies
breviaries1564003breviaries
briards10398553briar_ds
briars84814823briar__s
briberies1348333briberies
brinies93317913bri_nies
brionies10310543brionies
bursaries1157643bursaries
canaries10318943canaries
caries85147623__caries
chivaries1757433chivaries
claries93422203_claries
covaries13413253covaries
crazies183413853cr_azies
dairies84217733dai_ries
dataries9314033dataries
dearies83526273_dearies
drearier9297923drearier
dreariest10229123dreariest
facies113921593f__acies
faeries104118993f_aeries
fakeries1559833fakeries
farces115223323f__arces
farcies125317883f__arcies
fares85852873f__ar_es
farles96025783f__arles
farrieries1344343farrieries
feirie939553fei_rie_
feodaries1346373feodaries
ferities111416713feri_ties
ferneries1239043ferneries
ferries103521083f_erries
feudaries1345883feudaries
fiacres1237253f_iacres
fiances12310673f_iances
fiars86720833f_iar__s
fibres114312123f_ibr_es
fibrils1236843f_ibrils
fibrins1238633f_ibrins
fierier103511193f_ierier
fieriest112112243f_ieriest
fifties132111083f_ifties
filarees1187643filarees
fillies103420253f_illies
fineries112416743fineries
fires85740753f_i_r_es
firrier103410133f_irrier
firriest112310433f_irriest
flares94521703f_lar_es
flimsies1335783flimsies
flurries11188913flurries
forgeries13310003forgeries
formicaries1853643formicaries
frails93716473fr_a_ils
frailties1245853frailties
fraise94214913fr_a_ise
fraises104215693fr_aises
frames115119863fr_a_mes
frappes14328383fr_appes
frasses104314513fr_asses
frazils1956123fr_azils
freakier15246483freakier
freakiest16206693freakiest
freebies1337873freebies
frenzies2037713frenzies
freres94716173fr_er_es
friable122612563friable_
friar85414273friar___
friarbird1551343friarbird
friarbirds1651213friarbirds
friarly13316213friar_ly
friary124010093friar__y
fribbles15287713fribbles
fricatives1844683fricatives
fridges12369483fri_dges
friers94718933frier__s
fries85535603f___ries
friezes19418913fri_ezes
frigates12310933frigates
friges104116483fri__ges
frijoles1834373frijoles
frillier1136513frillier
frilliest1237113frilliest
fringes113514103fri_nges
fringier1236553fringier
fringiest1347603fringiest
fripperies1743583fripperies
frisbees13295013frisbees
frisees104411693fri_sees
frises94124273fri__ses
friskier1535193friskier
friskiest1636233friskiest
frites94922483fri__tes
fritzes19329453fri_tzes
frizes184015463fri__zes
frizzes18338183fri_zzes
frizzier19284813frizzier
frizziest20294143frizziest
frizzles19297283frizzles
furies95126373f__uries
furrieries1343943furrieries
gramaries12128313gramaries
granaries10159883granaries
gravies11314093gr_avies
grigris934093grigri_s
laniaries9411223laniaries
notaries8314933notaries
ordinaries1146253ordinaries
orreries8310123orreries
ostiaries948803ostiaries
ovaries10312653_ovaries
paries84742513__paries
piracies12312643piracies
prairie938333prairie_
predries112714383predries
primacies1548453primacies
prissies101712003prissies
privacies1646803privacies
privies122414263pri_vies
quinaries1857873quinaries
rabies85226023_r_abies
ramies84630463_r_amies
rares55247443_r_ar_es
readies83324713_readies
redries83721713_redries
refries104419733_refries
retries74129073_retries
rivalries1245003_rivalries
roadies83317443_roadies
rosaries8312783rosaries
rotaries8315693rotaries
salaries8319593salaries
sudaries9312753sudaries
ternaries9311643ternaries
tertiaries1047003tertiaries
topiaries1147113topiaries
treaties8316983treaties
triacids1146723triacids
triadics1146133triadics
triages82613793tria_ges
triarchies1544553triarchies
triazines1847543triazines
triazins1738353triazins
trilbies1037693trilbies
turbaries1147743turbaries
urares64519093ur_ar_es
uraris63817273ur_ari_s
vagaries12310293vagaries
varies94330873__varies
vivaries1439263vivaries
votaries11312013votaries
wearies103020223_wearies
whirries14136693whirries

Search took 9 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.436409841.7
2DLD Change Limit1461621718.17317883.5
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.67220605.5
 
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.