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

318 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
strained941225(None) 
sprained1138431sprained
stained84215341st_ained
strainer8512221strainer
trained84117201_trained
attained997352attained
brained103816102_brained
detrained1158912detrained
distrained1257672distrained
drained93713252_drained
entrained1089412entrained
grained93814272_grained
mistrained1347582mistrained
rained75024602__rained
restrained1148412restrained
retrained10411312retrained
sained75424242s__ained
sardined10268662sardined
shrined114112412shr_ined
stainer73614922st_ainer
staned74824642st_a_ned
strafed114413332stra_fed
strain64919572strain__
strainers9510382strainers
strains74218152strain_s
straiten838612straiten
straitened1143782straitened
straiter8311782straiter
straked125415342stra_ked
strand74514822stra_n_d
stranded102710812stranded
strapped1357822strapped
strawed114813612stra_wed
strayed114513282stra_yed
striated93414152striated
stringed102911872str_inged
striped105214362str_iped
strived114713662str_ived
traiked123310452_traiked
trailed83415672_trailed
trainee72817792_trainee
trainer73316792_trainer
trined74920712_tr_ined
unstrained1146372unstrained
untrained10510992untrained
abstained1245053abst_ained
arraigned11103033arraigned
astringed1145693astr_inged
atrazine1748403atrazine_
atrazines1846683atrazines
attainer8116913attainer
attainted1044693attainted
bargained1344953bargained
braided114013213_braided
brailed103914013_brailed
braised104014803_braised
branned104311693_branned
brined95118413_br_ined
chained133812693_chained
constrained1445353constrained
craned96121653_cra_ned
curtained1265503curtained
deraigned1244093deraigned
derailed102410403derailed
destained1158253dest_ained
detained103111643detained
distained1139603dist_ained
distrainer1146433distrainer
drainer83012843_drainer
engrained1145493engrained
entrainer968583entrainer
ermined10410603_ermined
estranged11387663estranged
estrayed1236393estra_yed
gained84617463__gained
grainer83714063_grainer
groined92710813_groined
ingrained1145383ingrained
margined1237743margined
moraine9314573moraine_
moraines10314363moraines
obtained1136533obtained
ordained1035183ordained
ostracised1343793ostracised
ostracized2254033ostracized
outgained1137223outgained
outraised1039243outraised
pained95622853__pained
pertained1238503pertained
plained103812233_plained
praised104214813_praised
prawned1346743_prawned
pretrained1357063pretrained
raided85017703__raided
railed74727543__railed
raised76120333__raised
ravined115411823__ravined
refrained1347223refrained
regained102111243regained
reined74425523__reined
remained112412893remained
reraised9312363reraised
restrainer1046973restrainer
retained93016093retained
retrainee9511163retrainee
ruined74813323__ruined
sailed74327763s__ailed
sainted84114243s__ainted
saned65636273s__a_ned
sardine83317393sardine_
sardines92815573sardines
scanned104110893s_canned
scragged1335823scragged
scraiched1744203scraiched
scraighed1643593scraighed
scrammed1555003scrammed
scrannel1044033scrannel
scraped124313143scra_ped
scrapped1556543scrapped
scrawled1445923scrawled
screened1137413screened
scribed124510643scr_ibed
scried95817313scr_i_ed
scrived134511113scr_ived
seined74023063s__eined
sequined18105653sequined
seriated92717023seriated
serifed11811463ser_ifed
serine65432673ser_ine_
serines74229543ser_ines
serried82513973serri_ed
serviced1435613serviced
shined104620783s__hined
shrapnel1342133shrapnel
shrine94920053shr_ine_
shrines104618693shr_ines
shrived144712183shr_ived
skeined1236773s_keined
snailed83811923s_nailed
sordine82515233sordine_
sordines92414073sordines
sorned74820043sor__ned
sortied83314103sorti_ed
spanned104111223s_panned
spavined1434333spavined
spawned13316803s_pawned
speaned103411523spea_ned
spined95423943s__pined
splined105013113s_plined
sprain83614863sprain__
sprains93013593sprain_s
sprawled1434523sprawled
sprayed13398903spra_yed
springed123911323spr_inged
sprinted113411163spr_inted
stabbed123510373st_abbed
stabled103514953st_abled
stacked143416123st_acked
staffed14298283st_affed
staged84521563st_a_ged
stagged104212083st_agged
staid66722083st_ai__d
staider83912613st_aider
stain55727943st_ain__
stainers83212173st_ainers
stains64923653st_ain_s
staked114621943st_a_ked
staled74728103st_a_led
stalked123811173st_alked
stalled83515693st_alled
stamened1137633stamened
stamped124812813st_amped
stand65923283st_a_n_d
stane55933003st_a_ne_
stanes64933403st_a_nes
stanged94113853st_anged
stanine73417073stanine_
stanines85115673stanines
stapled103613703st_apled
starched14199313starched
stared75429873st_a_red
staring84527053starin_g
starred85013453st_arred
started84217323st_arted
startled9208563startled
starved114911573st_arved
stashed113812493st_ashed
stated75427833st_a_ted
stationed1046143stationed
statued8459893st_atued
staved103918053st_a_ved
stayed104817273st_a_yed
steaded92811673stea_ded
steadied1036563steadied
steamed103712143stea_med
stearine8311903stearine_
stearines9311283stearines
stibine938663stibine_
stibines1038153stibines
stied65723033st__i_ed
stimied10310623stimi_ed
stinted82914193st__inted
stiped94517073st__iped
stoned75923143st__oned
storied8515163stori_ed
straddled12205023straddled
strafe95215983stra_fe_
strafer103912463stra_fer
strafes104516003stra_fes
strafing122111193strafin_g
straggled12296853straggled
straight1249183straight
straighted1544863straighted
straining10410563straining
strait64025893strai__t
straitens946233straitens
straitest949173straitest
straitly1136563straitly
straitness1046293straitness
straits74916323strai_ts
strake104017393stra_ke_
strakes114218073stra_kes
strander97112063strander
strands83711953stra_nds
strang75718313stra_n_g
strange85416343stra_nge
stranger94715103stranger
stranges94516763stranges
strangled11268983strangled
strapper1258093strapper
strasses81311443strasses
stratified1445173stratified
stravaged1444193stravaged
stravaiged1552233stravaiged
strawier1137493strawier
strawing122411623strawin_g
strayer104312503stra_yer
straying122912693strayin_g
streaked13228453streaked
streambed1483333streambed
streamed11258903streamed
streamlined1452253streamlined
streeked13246153streeked
streeled9267873streeled
stressed9128543stressed
strewed115811343str_ewed
striae65422273str_iae_
striate74218953striate_
striates83417083striates
stride75420963str_ide_
strider84315723str_ider
strides84520393str_ides
strife95318363str_ife_
strifes104716583str_ifes
strike105619733str_ike_
striker113714173str_iker
strikes114719093str_ikes
string75327563str_in_g
stringer93812943str_inger
strings84617133str_ings
stringy114111073str_ingy
stripe85822443str_ipe_
striper94514793str_iper
stripes95320573str_ipes
stripped1357093stripped
strive95020963str_ive_
striven103910753str_iven
striver104315203str_iver
strives104119373str_ives
stroked124613623str_oked
strolled937823strolled
stropped1367353stropped
strowed115312143str_owed
stroyed114110863str_oyed
strummed1344473strummed
strunted957243strunted
strutted946343strutted
studied9268693studi_ed
stunned8358893st_unned
sturdied10215963sturdi_ed
stylised12215893stylised
stylized21175873stylized
stymied1335663stymi_ed
surmised1136863surmised
survived1534073survived
sustained1045383sustained
swanned11358173s_wanned
syringed13377583syr_inged
tailed74424663_t_ailed
tainted83512423_t_ainted
tanned75219963_t_anned
tined65434533_t__ined
traced94821583_tra_ced
tracked143716133_tracked
traded85717683_tra_ded
trailer73015393_trailer
train56529113_train__
trainees82712063_trainees
trainers83114643_trainers
trainmen1046153_trainmen
trains64725343_train_s
traipsed1134753_traipsed
trammed123810713_trammed
tramped124312433_tramped
tranced104414173_tranced
trapped124512213_trapped
trashed113514703_trashed
trawled113411523_trawled
triaged92810443_triaged
triced95518673_tr_iced
tried65026913_tr_i_ed
trine54734603_tr_ine_
trines64132563_tr_ines
twined104413123_t_wined
undrained1138523undrained
unraised91811883unraised
unstained1038683unst_ained
upraised11167413upraised

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623186.86021306.4
3Display Results3183180.1232585.4
 (SQL Overall)1786913187.40624127.9
 
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.