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

153 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
armories1031365(None) 
armoires1057621armoires
armouries1146231armouries
almonries1156922almonries
ambries111614532a_mbries
arbores94016032arbor_es
arborizes2088812arborizes
argosies939522argosies
armies85123692arm__ies
armoire938132armoire_
armored102610472armor_ed
armorer9259902armor_er
armorers10288962armorers
armorial1049452armorial
armorials1145652armorials
armoring1149122armoring
armorless1143482armorless
armors85017812armor__s
armures9510272armur_es
arteries8321462arteries
harmonies141311042harmonies
memories121214342memories
priories10312452priories
acrimonies1445043acrimonies
admires1038663admir_es
adores74420713a_dor_es
aeries64737783a__eries
agonies83016623a_gonies
agrimonies1343403agrimonies
alimonies1198333alimonies
ambaries123312353ambaries
amberies122514673amberies
amerces1149853a_merces
amies76837683a_m__ies
amities9317383a_mities
ammonias1247943ammonias
ammonites1348133ammonites
amoles84122193a_mo_les
amorini9310353a_morini
amorino9310253a_morino
amorist9317643a_morist
amorists10411323a_morists
amorous9311133a_morous
amortise10428513a_mortise
amortises1178823a_mortises
amortizes2087273a_mortizes
amosites10311233a_mosites
angaries9314383angaries
anomies93316983a_nomies
aperies9423203a_peries
aphorise1339983aphorise
aphorises14310003aphorises
aphorizes2348003aphorizes
apiaries10312713apiaries
aporias9315133a_porias
arbored103811603arbor_ed
arborist10411613arborist
arborists1147443arborists
arborize1988963arborize
arborized2166963arborized
arborous1047713arborous
arbors84717873arbor__s
archeries14411213archeries
ardors74416863ardor__s
areoles71016953areo_les
argufies1243743argufies
arkoses113910833arko_ses
armers85520273armer__s
armholes1347383armholes
armonica1276863armonica
armonicas13106123armonicas
armor75118053armor___
armory114211473armor__y
armoured1165223armoured
armourer1054883armourer
armourers1154063armourers
armouring1244983armouring
armours9389843armo_urs
armpits1157123arm_pits
armrest9310163arm_r_est
armure8710133armur_e_
aroids75118223ar_o_ids
arouses74921293ar_ouses
arris56824683ar__ri_s
arrises71617583ar__rises
arrives101311513ar__rives
astonies8815093astonies
atomies93918363a_tomies
atonies75320953a_tonies
atopies92816433a_topies
auguries947933auguries
aviaries1139773aviaries
baronies10315023bar_onies
brionies10310543brionies
brookies1459143brookies
bryonies1336843bryonies
calories102919543calories
carries94328013car__ries
cronies9622503cr_onies
crores86121163cr_or_es
dories75232363__dories
drearies92313413drearies
emeries91620023_emeries
factories14810093factories
friaries11310083friaries
glories81915913_glories
gramaries12128293gramaries
harlotries1345683harlotries
harmonics16107403harmonics
harmonise14148763harmonise
harmonises15148373harmonises
harmonizes24147593harmonizes
harries103525493har__ries
ironies7517423ir_onies
ivories10310713_ivories
lories64933043__lories
marries93825283mar__ries
martyries1446563martyries
memorise121411433memorise
memorises131211573memorises
memorizes221310813memorizes
moires8915633__moires
molies84429513__molies
monies83233163__monies
mores76249643__mor_es
movies115118453__movies
moxies154317403__moxies
oratories9410633oratories
orreries8310123orreries
parodies11313693par_odies
parries93925843par__ries
prairies10411453prairies
predries112714383predries
primaries13410833primaries
proxies163014933pr_oxies
ramies84630463ram__ies
ramifies13310503ramifies
ramilies10311833ramilies
redries83721713_redries
refries104419733_refries
remorses10311993remorses
retries74129073_retries
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
sartorius947163sartorius
savories11311273savories
simonies10311113simonies
stories7324273_stories
tarries73324263tar__ries
theories11311593theories
tories65435883__tories
warhorses1545573warhorses

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.1561145455.1
2DLD Change Limit1461621537.89018525.0
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.