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 “acrogens” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
acrogens114724(None) 
acrogen1038191acrogen_
acrogenic1447752acrogenic
acroleins1145532acroleins
aerogels945592aerogels
androgens1145252androgens
cryogens1444722_cryogens
kerogens1345762kerogens
pyrogens1437292pyrogens
abdomens1345243abdomens
acnodes1037823acnode_s
acorns85013013ac_o_rns
acrasins1039973acrasins
acreages1138363acreage_s
acres76327763acr__e_s
acrobats1258343acrobats
acrodont1148123acrodont
acrodonts1244523acrodonts
acrolect1247413acrolect
acrolects1344323acrolects
acrolein1045843acrolein
acronyms1544993acronyms
across8312643acro__ss
acumens1136953ac_umens
aerobes9311493aerobe_s
aerogel836523aeroge_l
agnomens1144893agnomens
amidogens1343653amidogens
amylogens1543603amylogens
androgen1046313androgen_
antigens9310603antigens
apogees1037103a_pogees
aprons8316993apro__ns
argent74023663a_r_gent
argents84014853a_r_gents
argons75018203a_r_gons
arpens84814823a_r_pens
arrogant949153arrogant
atropins10410493atropins
autogeny1245233autogeny
autopens1046633autopens
baclofens1642173baclofens
biogens1038963_biogens
brogans1049663_brogans
carageens1264723carageens
careens94514703car_eens
cargoes104415223cargoe_s
carolers103314173carolers
carotene1039133carotene
carotenes11410203carotenes
carotins102315583carotins
codens94821013_c_odens
cogent9321003_c_ogent
cogons96818113_c_ogons
copens106119963_c_opens
covens114919263_c_ovens
cozens176314923_c_ozens
cravens124010113_cravens
croceins1238103_croceins
crones84729243_crone_s
croons85418423_cro_ons
crores86121163_crore_s
crotons93714373_crotons
crowers124614893_crowers
crowns115615113_cro_wns
crozers184111083_crozers
crozes174417663_croze_s
cryogen1345043_cryogen_
cryogeny1743553_cryogeny
dacrons103211033dacro__ns
endogens1047953endogens
estrogens1045703estrogens
exogens1536883_exogens
halogens1237363halogens
hydrogens1746063hydrogens
ionogens956823ionogens
kerogen1236083kerogen_
lysogens1244523lysogens
macrons113514893macro__ns
mitogens1146973mitogens
morgens10310463mor_gens
naproxens1842513naproxens
nitrogens1045353nitrogens
orogeny11107023_orogeny
pathogens1545713pathogens
pirogen1038263pirogen_
progeny1389463_progeny
pyrogen1337353pyrogen_
rogers74517913__rogers
rouens64814443__rouens
rowens94515303__rowens
screens95212173scr_eens
scrooges1137163scrooge_s
scrouges1136683scrouge_s
trogons83410713_trogons
zymogens2343673zymogens

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 Limit146162968.20317818.1
3Display Results96960.0303200.0
 (SQL Overall)178691968.38921300.6
 
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.