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

182 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
strophe123914(None) 
strophes13310601strophes
atrophy1546182atrophy
soroche1237182soroche
stope74727242st_op_e
stripe85822442strip_e
strobe84513812stro_be
strode75215972stro_de
stroke105116172stro_ke
strop77422242strop__
strophic1569002strophic
stropped1367342stropped
stropper1247762stropper
stroppy14205092stroppy
strops86220382strop_s
strove95014792stro_ve
tophe106718972_t_ophe
troche113112512_troche
trope75725802_trop_e
trophy1438282_trophy
anastrophe1583693anastrophe
apostrophe1753753apostrophe
atrophia1348103atrophia
atrophic1549373atrophic
atrophied1546063atrophied
atrophies14410093atrophies
atropin9311583atropin
atropine10410113atropine
broche133612103_broche
caroche1469243caroche
dystrophy2152533dystrophy
epistrophe1773083epistrophe
estrone7413953estro_ne
eutrophy1643943eutrophy
exstrophy2452363exstrophy
grope84821613_grop_e
prophet14316033_prophet
pyrope132810533pyrop_e
raphe104916423__raphe
rope65542913__rop_e
sarape84817573sarap_e
sarode75317513saro_de
scope94821483s_cop_e
scrape105917573scrap_e
scrapie115010943scrapie
scrooge1037183scrooge
scrouge1036353scrouge
scruple1137193scruple
serape84818413serap_e
seraph114011163seraph_
seraphs12408093seraphs
serosae7310243serosae
shoppe133110323s_hoppe
shrove125412233shro_ve
sinopie948783sinopie
slope75823563s_lop_e
soothe94214853s_oothe
soph97024203s__oph_
sophs104916023s__ophs
sophy136611763s__ophy
soroches1338803soroches
staithe1037723staithe
staph104314653st_aph_
staphs114411033st_aphs
staple84415823st_aple
steeple937323steeple
steppe10319873st_eppe
stipe76523373st_ip_e
stipple1146623stipple
stoae55024263st_o_ae
stodge8369043st_odge
stogie7311323st_ogie
stoke94922513st_o_ke
stole54928813st_o_le
stone55431183st_o_ne
stooge73811663st_ooge
stoolie739723stoolie
stoop75821543stoop__
stooped103813833stooped
stooper93813193stooper
stoops85917893stoop_s
stop66532033st_op__
stoped94721013st_oped
stoper84320103st_oper
stopes84525893st_opes
stopped124512203st_opped
stopper113012603st_opper
stopple1156583stopple
stops74827283st_op_s
stopt76528353st_op_t
storage8310473storage
store56333813st_o_re
stoure64814943st_oure
stove85220253st_o_ve
strafe95215983str_afe
strake104017393str_ake
strange85416343strange
strap77925263strap__
strapped1357823strapped
strapper1258093strapper
strappy14205263strappy
straps87721783strap_s
strath93216373strath_
straths102711723straths
strep77120853strep__
streps86218063strep_s
strette7310763strette
striae65422273str_iae
striate74218953striate
stride75420963str_ide
strife95318363str_ife
strike105619733str_ike
strip77524343strip__
striped105214363striped
striper94514793striper
stripes95320573stripes
stripier1058863stripier
stripped1357093stripped
stripper1247123stripper
strips85719653strip_s
stript85222193strip_t
stripy115812743strip_y
strive95020963str_ive
strobes93813263strobes
strobic1138253strobic
strobil936963strobil
strobile1047033strobile
stroked124613623stroked
stroker114113523stroker
strokes114316323strokes
stroll6311603stro_ll
strolled937813strolled
stroller848173stroller
strolls739183strolls
stroma84313073stro_ma
stromal93010593stromal
strong74914883stro_ng
stronger9349693stronger
strook10410303stro_ok
strophoid1567203strophoid
strophuli1454073strophuli
stroppers1356713stroppers
stroppier1364453stroppier
stroud7310383stro_ud
strouds837803strouds
strow88920573stro__w
strowed115312143strowed
strown96812093stro_wn
strows96718273stro_ws
stroy87720393stro__y
stroyed114110863stroyed
stroyer103510783stroyer
stroys95914603stro_ys
strumae9368093strumae
stupe75217753st_up_e
tope65946383_t_op_e
topee76029953_t_opee
toph96326873_t_oph_
tophes115218423_t_ophes
tophi105215303_t_ophi
tophs105220053_t_ophs
tripe75425383_trip_e
triple84215923_triple
trochee122613883_trochee
troches123715343_troches
trode65322853_tro_de
troke94821053_tro_ke
trompe105611263_trompe
trone55131863_tro_ne
trop66833303_trop__
tropes84824353_tropes
trophic14311033_trophic
trophied1437643_trophied
trophies13413673_trophies
tropic103014193_tropic
tropin83316753_tropin
tropine93116653_tropine
troth85622203_troth_
trothed114010973_trothed
troths95414153_troths
troupe84812433_troupe
trove85221923_tro_ve

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.423422437.4
2DLD Change Limit1340271826.39020974.5
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.87625987.6
 
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.