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

187 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
angaries931439(None) 
angarias9310551angarias
agarics10319942a_garics
ambaries123312382ambaries
angaria8311582angari_a
angrier839022ang_rier
angriest9310252ang_riest
apiaries10312732apiaries
auguries947932auguries
aviaries1139782aviaries
canaries10318942can_aries
jaggaries18135742jaggaries
laniaries9411222laniaries
mangabies1446372mangabies
sangarees1046542sangarees
vagaries12310292vagaries
abbacies1445483abbacies
acarids105312243a_carids
acarines10314343a_carines
actuaries1147573actuaries
aeries64737783a__eries
affaires1444303affaires
agamids11317013a_gamids
agapes95212413a_ga_pes
agaric93513643a_gari_c
agarose838673a_garose
agaroses938823a_garoses
agars66120643a_gar__s
agates76121343a_ga_tes
agatizes1838863a_gatizes
agaves104611513a_ga_ves
aggies83515513a_g_gies
aggrades1135863aggrades
agnails837003agna_ils
agnates82813193agna_tes
agonies83016623a_gonies
agrafes1137523a_grafes
agrees74915323a_g_rees
agrias74315393a_g_rias
algerines1069083algerines
alkalies12158543alkalies
ambaris113112163ambari_s
amberies122514683amberies
ambries111614553a_mbries
anagoges10187243anagoges
anagogies11156163anagogies
anagrams1146593anagrams
anankes1138763an_ankes
anarchies1448183an_archies
anarchs1237093an_archs
andantes9310853andantes
aneared8512743anear_ed
anearing9413973anearing
anears63717183anear__s
anergies9310453anergies
aneurins849073aneurins
angakoks1241883angakoks
angary10311323angar__y
angas65827993anga___s
angered93013473anger_ed
angering102113803angering
angerless1045023angerless
angers75222543anger__s
angles74426703ang__les
angoras8811363angor_as
angrily1137723ang_rily
angriness1036453ang_riness
animacies1348593animacies
ankerites1348523ankerites
anlaces92313733anla_ces
anlages82414113anla_ges
anlases72514903anla_ses
annates72415423anna_tes
anomalies1149283anomalies
anomies93316993an_omies
anserines9411293anserines
antacids1148333antacids
antiarins9413893antiarins
anticaries12412473anticaries
antres65021003an_tr_es
anurias7312253an_urias
aperies9423203a_peries
apogamies1445323apogamies
argalis84214193argali_s
argosies939523argosies
argufies1243743argufies
armories10313653armories
arteries8321483arteries
ascarides12346953ascarides
ascarids11438503ascarids
ascaris93613323ascari_s
ataxies142410013a_taxies
autarkies1344773autarkies
avarices1337183a_varices
avgases11106313avga_ses
avgasses1284193avgasses
beggaries1356233beggaries
bigamies1337373bigamies
binaries10314183binaries
calvaries1449803calvaries
canneries11313083canneries
canonries1148413canonries
caries85147623__caries
claries93422203_claries
congeries12316403congeries
covaries13413253covaries
dataries9314033dataries
dearies83526273_dearies
diaries83321953_diaries
digamies1238643digamies
drearies92313413drearies
dungarees1143153dungarees
engages92912493enga_ges
engorges1045753engorges
engrails945383engrails
engrains937583engrains
engraves1237233engraves
enlarges946073enlarges
entries71523163en_tries
fanfares1436773fanfar_es
fantasies1298853fantasies
friaries11310083friaries
gabies93820733__gabies
gantries91413793gan_tries
granaries10159883gran_aries
hangared1337573hangar_ed
hangaring1438033hangaring
hangars114313493hangar__s
hangfires1643843hangfires
hegaris11310433hegari_s
infamies1346683infamies
infares10313023infar_es
ingates82716913inga_tes
ingrains948983ingrains
ingrates9514173ingrates
injuries1567683injuries
jaggeries18136973jaggeries
janisaries1744783janisaries
janizaries2643503janizaries
kangaroos1473113kangaroos
langrages11105903langrages
legacies1139043legacies
lingeries10511813lingeries
mandarins12410393mandarins
manganins1247123manganins
manganites1347033manganites
margarines1347203margarines
margarins1248293margarins
margarites1346533margarites
naperies10313903naperies
nares55544153_n_ar_es
naris55735293_n_ari_s
navies95218623_n_avies
notaries8314933notaries
oogamies1147413oogamies
orangeries11116943orangeries
ovaries10312653_ovaries
panfries13149203pan_fries
pantries101817393pan_tries
paries84742513__paries
pugarees11195493pugarees
puggries12166383puggries
quandaries2064413quandaries
rosaries8312783rosaries
rotaries8315693rotaries
salaries8319593salaries
sangaree949333sangar_ee
sangars83116253sangar__s
sangrias938373sang_rias
sanitaries1049913sanitaries
snares65329033sn_ar_es
stannaries1045783stannaries
sudaries9312753sudaries
sugarier937393sugarier
sugariest1038143sugariest
syngamies1544643syngamies
tangerines1147543tangerines
tanneries9310423tanneries
ungarbed12197063ungarbed
unvaried1239683unvaried
unwarier1136883unwarier
unwariest1246033unwariest
varies94330873__varies
vivaries1439263vivaries
votaries11312013votaries
waggeries14127463waggeries
wearies103020223_wearies

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621876.86021306.4
3Display Results1871870.0802337.5
 (SQL Overall)1786911877.34324334.9
 
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.