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

222 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
astride831197(None) 
stride75420961_stride
ascribe1147742ascribe
aside65122082as__ide
astrict9614792astrict
astringe938222astringe
attrite7311832attrite
bestride1138612bestride
nitride82811242nitride
outride82615682outride
striae65422272_striae
strider84315722_strider
strides84520392_strides
strife95318362_strife
strike105619732_strike
stripe85822442_stripe
strive95020962_strive
strode75215972_strode
wastrie101210302wastri_e
abide86223713a__bide
abrade9313053a_brade
abridge1135693a_bridge
abstrict1257943abstrict
abstruse1065513abstruse
acarid95017073acarid_
acarids105312243acarids
acarine9316003acarine
acrid86920103a_crid_
acrider1038623a_crider
actinide11199213actinide
active11313743act_ive
aerie54634603a_eri_e
aeried74221863a_eried
aggrade1035643aggrade
aide56045003a___ide
airstrike1384143airstrike
airtime948063airtime
alcaide1088453alcaide
amide86128483a__mide
anserine8313093anserine
antired82316193antired
antlike11312073antlike
antre55224523antr__e
apprise11310193apprise
apprize2038183apprize
arid57642713a__rid_
arider74717743a__rider
arise56436433a__rise
arrive91311793a_rrive
arsenide9116333arsenide
ascarid103910723ascarid_
ascarides12346953ascarides
ascarids11438503ascarids
ascribed1374693ascribed
ascribes1246193ascribes
asides75118873as__ides
asinine7310723asinine
aspire8612123as_pire
aspired1068173aspired
assize1538633as_size
asslike1137373asslike
astatine8313533astatine
asteria7316183asteri_a
asterias8317013asterias
asterisk1248673asterisk
asterism10413253asterism
asteroid9511193asteroid_
asteroids1048743asteroids
astilbe945653astilbe
astir55517093ast_i_r
astonied978983astonied
astraddle1142873astraddle
astral66919283astr_al
astrals75515243astrals
astray95615543astr_ay
astricted1247443astricted
astricts1049463astricts
astringed1145693astringed
astringes1038333astringes
astrodome1254513astrodome
astute6310763ast_ute
atria56022343a_tri_a
atrial65418943a_trial
atrip75315753a_tri_p
atrium8411823a_trium
attire62412383a_ttire
attired8238913attired
attrit6315753attri_t
attrited947373attrited
attrites8311563attrites
attrits7310613attrits
avarice1238033avarice
azide155617163a__zide
azurite1638003azurite
bastile9313913bast_ile
bestrid1039973bestrid_
bestrides1237913bestrides
bestrode1147143bestrode
betide95115973bet_ide
boride9415903_boride
bride86425533__bride
cartridge1372723cartridge
castrate10313863castrate
citrine92514023citrine
debride1138593debride
deride84420033_deride
detrude936083detrude
eserine7415903eserine
estrin6315923estri_n
estrins7315853estrins
estriol747553estriol
estrone7413953estrone
extrude1545013extrude
gastric1038643gastri_c
gastrin839833gastri_n
gastrins9310123gastrins
gride75223583__gride
hagride1237553hagride
hayride1437323hayride
hydride15257503hydride
intrude837403intrude
joyride1853753joyride
laetrile845203laetrile
latrine7715133latrine
mastlike1437863mastlike
mastoid10711233mastoid_
mastoids1177873mastoids
nitrid72812233nitrid_
nitrided10276753nitrided
nitrides92910703nitrides
nitrids8269633nitrids
nitrile73011373nitrile
nitrite72314463nitrite
obtrude1044243obtrude
ostrich1238663ostrich
outrider92410563outrider
outrides92414993outrides
outrode82313423outrode
outside82414193outside
outstride1085773outstride
partridge1362863partridge
pastie85525523past_i_e
pastime114611973past_ime
pastries101517423pastries
postrider1246653postrider
pride84724733__pride
putrid9311173putrid_
restrike1239673restrike
restrive11310923restrive
retried84419153retried
ride55945133___ride
sarode75317513_sarode
satire63218003sat_ire
satirise8310683satirise
satirize1749703satirize
satyrid1137233satyrid_
satyrids1245623satyrids
scribe104613533_scribe
scried95817303_scried
scrive115414943_scrive
serine65432673_serine
shrike134513243_shrike
shrine94920053_shrine
shrive125216953_shrive
side55444493_s__ide
slide64725413_s_lide
snide64318723_s_nide
sprite84421773_sprite
stade64825303_st_ade
staid66722083_staid_
staider83912613_staider
sterile7316603_sterile
stied65723033_st_ied
stile54931573_st_ile
stime76521803_st_ime
stipe76523373_st_ipe
storied8515163_storied
strafe95215983_strafe
strake104017393_strake
stria55723213_stri_a
striate74218953_striate
strick124813203_strick
strict84821043_strict
stridden1044273_stridden
strident9310173_strident
striders94412123_striders
stridor8467393_stridor
strifes104716583_strifes
striker113714173_striker
strikes114719093_strikes
string75327563_string
strip77524343_stri_p
striped105214363_striped
striper94514793_striper
stripes95320573_stripes
strips85719653_strips
stript85222193_stript
stripy115812743_stripy
strived114713663_strived
striven103910753_striven
striver104315203_striver
strives104119373_strives
strobe84513813_strobe
stroke105116173_stroke
strove95014793_strove
strudel835783_strudel
tetrode839343tetrode
tide55237383__t_ide
trade65026043__trade
tribe74420273__tribe
trice75127493__trice
tried65026913__tried
trike95320163__trike
trine54734603__trine
triode75311893__triode
tripe75425383__tripe
trite54730033__trite
trode65322853__trode
untried82615853untried
vitrine102511363vitrine
wasterie111211583wasteri_e
wastries111212883wastries

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 Filter1786911340270.610292936.1
2DLD Change Limit1340272227.18618651.1
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.87622688.0
 
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.