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

154 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
astrict961479(None) 
abstrict1257941abstrict
astricts1049461astricts
strict84821041_strict
abstract1249222abstract
abstricts1355182abstricts
astricted1247442astricted
astride8311972astride
attract9511832attract
attrit6315752attri_t
district11413872district
gastric1038632gastric_
ostrich1238662ostrich
restrict10313632restrict
strick124813202_strick
stript85222192_stript
abstracts1346593abstracts
abstricted1544093abstricted
addict10711203a_ddict
adrift10313113a_drift
adscript1344203adscript
afflict1547043afflict
afrit8323173a_fri_t
agaric93513633agaric_
agarics10319943agarics
altoist7313393altoist
altruist857953altruist
amorist9317643amorist
amtrac10109123amtrac_
amtrack15107393amtrack
amtracs1198883amtracs
antic75728863ant_ic_
antick124814583ant_ick
antics84621453ant_ics
antiriot8414583antiriot
anuric8812103anuric_
aorist64827873a_orist
aortic8316613aortic_
apomict1349053apomict
apricot111010183a_pricot
artist64125543art_ist
ascribe1147743ascribe
asdic83814093as_dic_
asdics9439863as_dics
aspect10612823as_pect
aspic95114733as_pic_
aspics104211563as_pics
asquint16208323asquint
assist6314603as_sist
astatic9514193astatic_
asteria7316183asteri_a
asterias8317013asterias
asterisk1248673asterisk
asterism10413253asterism
astir55517093ast_i_r
astral66919283astr_al
astrals75515243astrals
astray95615543astr_ay
astricting1357833astricting
astringe938223astringe
astrocyte1465833astrocyte
atilt54828473a_t_ilt
atria56022343a_tri_a
atrial65418943a_trial
atrip75315753a_tri_p
atrium8411823a_trium
attaint7313473attaint
attic75618353a_ttic_
attics84413283a_ttics
attracts1047793attracts
attrite7311833attrite
attrits7310613attrits
auric74521733a_uric_
aurist65027253a_urist
autist64324943aut_ist
avarice1238033avarice
citric102812313citric_
constrict13711623constrict
destruct1148383destruct
detract101414633detract
distract11313023distract
districts1248933districts
esprit8312843espri_t
estreat7314813estreat
estrin6315923estri_n
estrins7315853estrins
estriol747553estriol
extract16311013extract
gastrin839833gastri_n
gastrins9310123gastrins
iatric8312163iatric_
instruct1047543instruct
mantric11311343mantric_
mastic103119173mast_ic_
mastics112614783mast_ics
metric10314673metric_
metrics11312363metrics
metrist9317063metrist
nastic82915973nast_ic_
nitric82512063nitric_
obstruct1246033obstruct
ostraca937823ostraca
pastries101517423pastries
patriot9314533patriot
postriot10412253postriot
restricts1138823restricts
retract91318113retract
sacrist9315423sacrist
satiric939243satiric_
satirist8313503satirist
satyric1237493satyric_
script105717903_script
shrift12413543_shrift
sprint84526793_sprint
sprit76736403_spri_t
steric8317063_steric_
stich104117923_st_ich
stick115121563_st_ick
stilt54831983_st_ilt
stint57037663_st_int
stoic7317253_stoic_
stoics8311113_stoics
strait64025893_strait
street64125773_street
stria55723213_stri_a
striae65422273_striae
striata7379953_striata
striate74218953_striate
stricks134310693_stricks
stricter1039423_stricter
strictly1345813_strictly
stride75420963_stride
strife95318363_strife
strike105619733_strike
string75327563_string
strip77524343_stri_p
stripe85822443_stripe
strips85719653_strips
stripy115812743_stripy
strive95020963_strive
struck12489263_struck
strunt64918913_strunt
strut56030733_str_ut
tantric939583tantric_
tract75635713__tract
trice75127493__trice
trick115420693__trick
tricot8317753__tricot
tsarist7712253tsarist
vitric112510113vitric_
vitrics12198553vitrics
wastrie101210303wastri_e
wastries111212883wastries
yttric1145433yttric_

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271546.06322105.7
3Display Results1541540.0463347.8
 (SQL Overall)1786911546.49927495.2
 
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.