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

117 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
astricts104946(None) 
abstricts1355181abstricts
astrict9614791astrict_
abstracts1346592abstracts
abstrict1257942abstrict_
astricted1247442astricted
attracts1047792attracts
attrits7310612attri_ts
districts1248932districts
restricts1138822restricts
stricks134310692_stricks
strict84821042_strict_
abstract1249223abstract_
abstricted1544093abstricted
addicts1176013a_ddicts
adscripts1442323adscripts
afflicts1644003afflicts
afrits9311903a_fri_ts
agarics10319943agaric_s
altoists848753altoists
altruists945413altruists
amorists10411333amorists
amtracks1696633amtracks
amtracs1198883amtrac_s
anticks134612253ant_icks
antics84621453ant_ic_s
aorists74215833a_orists
apomicts1444193apomicts
apricots1275393a_pricots
artists74215593art_ists
ascribes1246193ascribes
asdics9439863as_dic_s
aspects1146743as_pects
aspics104211563as_pic_s
assists738473as_sists
asterias8317013asteri_as
asterisks1346813asterisks
asterisms11511063asterisms
astrals75515243astr_als
astricting1357833astricting
astride8311973astri_de
astringe938223astringe
astringes1038333astringes
astrocyte1465833astrocyte
astrocytes1565973astrocytes
atriums939043a_triums
attaints846493attaints
attics84413283a_ttic_s
attract9511833attract_
attrit6315753attri_t_
attrite7311833attri_te
attrites8311563attrites
aurists74615783a_urists
autists73814853aut_ists
avarices1337183avarices
constricts1477733constricts
destructs1245773destructs
detracts11138833detracts
distracts1249283distracts
district11413873district_
esprits938393espri_ts
estreats839423estreats
estrins7315853estri_ns
estriols856253estriols
extracts1747623extracts
gastric1038633gastric__
gastrins9310123gastri_ns
gastritis1045673gastritis
instructs1145793instructs
mastics112614783mast_ic_s
matrices12312083matrices
metrics11312363metric_s
metrists1039853metrists
obstructs1344573obstructs
ostrich1238663ostric_h
ostriches1446633ostriches
pastries101517423pastri_es
patriots1038053patriots
restrict10313633restrict_
retracts101111313retracts
sacrists1039563sacrists
satirists958923satirists
scripts11509373_scripts
shrifts1335963_shrifts
sprints94113773_sprints
sprits85122533_spri_ts
stichs114511653_st_ichs
sticks125118613_st_icks
stilts67915313_st_ilts
stints65119763_st_ints
stoics8311113_stoic_s
straits74916323_straits
streets73312613_streets
striata7379953_striata
striate74218953_striate
striates83417083_striates
strick124813203_stric_k
stricter1039423_stricter
strictest1147293_strictest
strictly1345813_strictly
strides84520393_strides
strifes104716583_strifes
strikes114719093_strikes
strings84617133_strings
stripes95320573_stripes
strips85719653_stri_ps
stript85222193_stript_
strives104119373_strives
strunts7429543_strunts
struts65616803_str_uts
tracts85019073__tracts
trices84826333__trices
tricks125319013__tricks
tricots9311563__tricots
tsarists857303tsarists
vitrics12198553vitric_s
wastries111212883wastri_es

Search took 10 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 Limit1461621179.04616157.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911179.24819322.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.