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
strainer8512211strainer
trained84117201_trained
attained997352attained
brained103816102_brained
detrained1158912detrained
distrained1257662distrained
drained93713252_drained
entrained1089412entrained
grained93814272_grained
mistrained1347582mistrained
rained75024602__rained
restrained1148412restrained
retrained10411312retrained
sained75424242s__ained
sardined10268662sardined
shrined114112412shr_ined
stainer73614922st_ainer
staned74824642st_a_ned
strafed114413322stra_fed
strain64919572strain__
strainers9510372strainers
strains74218152strain_s
straiten838612straiten
straitened1143782straitened
straiter8311772straiter
straked125415342stra_ked
strand74514822stra_n_d
stranded102710812stranded
strapped1357812strapped
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
constrained1445343constrained
craned96121653_cra_ned
curtained1265503curtained
deraigned1244093deraigned
derailed102410403derailed
destained1158253dest_ained
detained103111643detained
distained1139593dist_ained
distrainer1146423distrainer
drainer83012843_drainer
engrained1145493engrained
entrainer968583entrainer
ermined10410603_ermined
estranged11387663estranged
estrayed1236393estra_yed
gained84617463__gained
grainer83714063_grainer
groined92710813_groined
ingrained1145383ingrained
margined1237743margined
moraine9314573moraine_
moraines10314343moraines
obtained1136533obtained
ordained1035173ordained
ostracised1343793ostracised
ostracized2254033ostracized
outgained1137223outgained
outraised1039243outraised
pained95622853__pained
pertained1238493pertained
plained103812233_plained
praised104214813_praised
prawned1346743_prawned
pretrained1357063pretrained
raided85017703__raided
railed74727543__railed
raised76120333__raised
ravined115411823__ravined
refrained1347223refrained
regained102111243regained
reined74425523__reined
remained112412893remained
reraised9312353reraised
restrainer1046973restrainer
retained93016093retained
retrainee9511163retrainee
ruined74813323__ruined
sailed74327763s__ailed
sainted84114243s__ainted
saned65636273s__a_ned
sardine83317393sardine_
sardines92815563sardines
scanned104110893s_canned
scragged1335813scragged
scraiched1744203scraiched
scraighed1643593scraighed
scrammed1555003scrammed
scrannel1044033scrannel
scraped124313133scra_ped
scrapped1556533scrapped
scrawled1445903scrawled
screened1137403screened
scribed124510643scr_ibed
scried95817303scr_i_ed
scrived134511113scr_ived
seined74023063s__eined
sequined18105653sequined
seriated92717023seriated
serifed11811463ser_ifed
serine65432673ser_ine_
serines74229543ser_ines
serried82513963serri_ed
serviced1435613serviced
shined104620783s__hined
shrapnel1342133shrapnel
shrine94920053shr_ine_
shrines104618693shr_ines
shrived144712183shr_ived
skeined1236773s_keined
snailed83811923s_nailed
sordine82515223sordine_
sordines92414063sordines
sorned74820043sor__ned
sortied83314093sorti_ed
spanned104111223s_panned
spavined1434333spavined
spawned13316803s_pawned
speaned103411523spea_ned
spined95423943s__pined
splined105013113s_plined
sprain83614863sprain__
sprains93013593sprain_s
sprawled1434513sprawled
sprayed13398903spra_yed
springed123911313spr_inged
sprinted113411163spr_inted
stabbed123510373st_abbed
stabled103514953st_abled
stacked143416123st_acked
staffed14298283st_affed
staged84521563st_a_ged
stagged104212073st_agged
staid66722073st_ai__d
staider83912613st_aider
stain55727933st_ain__
stainers83212173st_ainers
stains64923653st_ain_s
staked114621943st_a_ked
staled74728103st_a_led
stalked123811173st_alked
stalled83515683st_alled
stamened1137633stamened
stamped124812813st_amped
stand65923283st_a_n_d
stane55933003st_a_ne_
stanes64933403st_a_nes
stanged94113843st_anged
stanine73417073stanine_
stanines85115663stanines
stapled103613693st_apled
starched14199313starched
stared75429873st_a_red
staring84527053starin_g
starred85013453st_arred
started84217323st_arted
startled9208553startled
starved114911573st_arved
stashed113812483st_ashed
stated75427833st_a_ted
stationed1046143stationed
statued8459893st_atued
staved103918053st_a_ved
stayed104817273st_a_yed
steaded92811673stea_ded
steadied1036563steadied
steamed103712143stea_med
stearine8311903stearine_
stearines9311283stearines
stibine938653stibine_
stibines1038143stibines
stied65723033st__i_ed
stimied10310613stimi_ed
stinted82914193st__inted
stiped94517073st__iped
stoned75923143st__oned
storied8515163stori_ed
straddled12205023straddled
strafe95215973stra_fe_
strafer103912443stra_fer
strafes104515993stra_fes
strafing122111193strafin_g
straggled12296853straggled
straight1249183straight
straighted1544863straighted
straining10410563straining
strait64025893strai__t
straitens946233straitens
straitest949173straitest
straitly1136563straitly
straitness1046283straitness
straits74916323strai_ts
strake104017393stra_ke_
strakes114218073stra_kes
strander97112053strander
strands83711953stra_nds
strang75718313stra_n_g
strange85416343stra_nge
stranger94715083stranger
stranges94516763stranges
strangled11268983strangled
strapper1258083strapper
strasses81311433strasses
stratified1445153stratified
stravaged1444193stravaged
stravaiged1552233stravaiged
strawier1137473strawier
strawing122411623strawin_g
strayer104312493stra_yer
straying122912693strayin_g
streaked13228453streaked
streambed1483333streambed
streamed11258903streamed
streamlined1452253streamlined
streeked13246153streeked
streeled9267863streeled
stressed9128543stressed
strewed115811333str_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_
striper94514783str_iper
stripes95320573str_ipes
stripped1357093stripped
strive95020963str_ive_
striven103910753str_iven
striver104315203str_iver
strives104119373str_ives
stroked124613623str_oked
strolled937813strolled
stropped1367333stropped
strowed115312143str_owed
stroyed114110863str_oyed
strummed1344473strummed
strunted957243strunted
strutted946343strutted
studied9268693studi_ed
stunned8358893st_unned
sturdied10215963sturdi_ed
stylised12215893stylised
stylized21175863stylized
stymied1335653stymi_ed
surmised1136853surmised
survived1534073survived
sustained1045373sustained
swanned11358173s_wanned
syringed13377583syr_inged
tailed74424663_t_ailed
tainted83512423_t_ainted
tanned75219953_t_anned
tined65434533_t__ined
traced94821583_tra_ced
tracked143716133_tracked
traded85717683_tra_ded
trailer73015393_trailer
train56529113_train__
trainees82712063_trainees
trainers83114633_trainers
trainmen1046153_trainmen
trains64725343_train_s
traipsed1134753_traipsed
trammed123810713_trammed
tramped124312433_tramped
tranced104414173_tranced
trapped124512213_trapped
trashed113514693_trashed
trawled113411523_trawled
triaged92810443_triaged
triced95518673_tr_iced
tried65026913_tr_i_ed
trine54734603_tr_ine_
trines64132563_tr_ines
twined104413123_t_wined
undrained1138513undrained
unraised91811873unraised
unstained1038673unst_ained
upraised11167413upraised

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.250714764.0
2DLD Change Limit1461623188.62316950.2
3Display Results3183180.1262523.8
 (SQL Overall)1786913188.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.