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

75 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
acridines124772(None) 
acridine1139551acridine_
accidies1338042accidi_es
acridities1348292acridities
acridness1245072acrid_ness
amidines113010852a_midines
pyridines1546472pyridines
uridines989512_uridines
aborigines1343503aborigines
abridges1245303abrid_ges
acaricides1543943acaricides
acaridans1254033acaridan_s
acarines10314343ac_arines
accidences1444403accidences
accidents14155133accidents
accidias1346333accidi_as
accidie1247733accidi_e_
acidifies15126453ac_idifies
acidities12810183ac_idities
acidness1136723ac_id_ness
acidoses1136773ac_idoses
acrasins1039973acrasin_s
acrider1038623acrid__er
acridest1138143acrid__est
acridity1446913acridi_ty
acrimonies1445043acrimonies
acrodonts1244523acrodonts
actinides12188323actinides
activizes2346323activizes
acuities10312453acuiti_es
aerifies111313393aerifi_es
aerodynes1344603aerodynes
airlines8312793air_lines
alcidine1148233alcidine_
amidine103613853a_midine_
amidins103713103a_midin_s
amidones11348663a_midones
anilines8415143a_nilines
arcadings1354393arcadings
archines133815253a_rchines
arcsines104010343a_rcsines
arginines1047053arginines
aridities10911633a_ridities
aridness939223a_rid_ness
arsines73518813a_r_sines
atrazines1846683atrazines
atropines1148883atropines
avidins11349003a_vidin_s
carabines13311473carabines
carbines123617543car_bines
cardings123812643car_dings
carlines103521653car_lines
carmines123617873car_mines
carnitines1277813carnitines
crimine112413473_crimine_
criminis12257303_criminis
crinites10612763_crinites
crudites1137763_crudites
cuisines1049373_cuisines
cytidines1544803cytidines
gradines103615253_gradines
ordines83014903_or_dines
primines123013703_primines
pteridines1345463pteridines
pyridine1447743pyridine_
ridings93412093__ridings
sacrifices17134413sacrifices
sanidines1048043sanidines
sardines92815573sar_dines
sordines92414073sor_dines
tacrines10310563tacr__ines
teredines1049453teredines
tolidines1046883tolidines
uridine81311213_uridine_
xylidines2042993xylidines

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 Filter1786911486410.406440125.6
2DLD Change Limit148641757.12620859.0
3Display Results75750.0302500.0
 (SQL Overall)178691757.56223630.1
 
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.