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

197 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
steward113806(None) 
stewards1236381stewards
leeward1135782leeward
reward106017642_reward
seaward1148182seaward
sewar85421102s_ewar_
sewars94018632s_ewars
sideward1345952sideward
skyward1843862skyward
stead65520272ste_a_d
stelar64013862stelar_
stemware1344882stemware
sternward1343122sternward
stewarded1443532stewarded
stewed104814242stew_ed
sunward1137652sunward
sward94221462s__ward
toward10311062_toward
afeard1058263afe_ard
afterward1664013afterward
airward1148133airward
athwart1348683athwart
award97118043__award
awkward1843183awkward
beard86024963_be_ard
bedward1497473bedward
beeyard1335523beeyard
beware11313713_beware
bewared13310113_bewared
cityward1742943cityward
coward12411673_coward
dewar95817733_dewar_
dewars105117073_dewars
diehard1237053diehard
eastward1244993east_ward
forward1438293forward
froward1436673froward
hayward1736413hayward
heard95222753_he_ard
homeward1745333homeward
inward10310333_inward
leewards1244983leewards
manward1349093manward
notecard1144113notecard
onward1039053_onward
outward11811403outward
petard95013803_petard
poleward1455943poleward
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
regard85215773_regard
rereward1246143rereward
retard75018933_retard
rewards114813993_rewards
rewarm115913493_rewarm
reword106321413_reword
saggard10358953saggard
sard55344243s___ard
sear47353843s_e_ar_
seared75232843s_e_ared
sears54744913s_e_ars
seawards1237203seawards
seaware1049633seaware
selfward1543093selfward
senary93716073s_enary
sewage10310733s_ewage
sewan85921293s_ewa_n
sewans95215903s_ewans
sewed95325163s_ew_ed
sewer84426223s_ewer_
sewered112911243s_ewered
sewers94719723s_ewers
shard96125963s__hard
shear85424833she_ar_
sheared114516013she_ared
shears93820903she_ars
sherd96321153she__rd
shewed134716183shew_ed
shewer124515113shewer_
shewers134312053shewers
shoreward1644093shoreward
sidewards1445053sidewards
skewbald1842073skewbald
skewed145610233skew_ed
skewer13519613skewer_
skewered1634213skewered
skewers14498383skewers
skywards1943373skywards
slewed104815523slew_ed
smear74416393sme_ar_
smeared104510623sme_ared
smears84714433sme_ars
smeary114110803sme_ary
southward1653933southward
sowar85821343s_owar_
sowars94318013s_owars
spaceward1743073spaceward
spear75821063spe_ar_
speared104314423spe_ared
spears84019473spe_ars
spewed125512333spew_ed
spewer115112153spewer_
spewers124210663spewers
staggard1144513staggard
staid66722083st__aid
stalwart1147193stalwart
stand65923283st__and
standard1046253standard
star48037763st__ar_
stare54440263st__are
stared75429873st__ared
stark95425623st__ark
stars55836573st__ars
start55642313st__art
steaded92811673steaded
steads74116223ste_ads
steady103510203ste_ady
steak95219803ste_a_k
steaks104415853ste_aks
steal56125473ste_a_l
steals64020063ste_als
steam76322933ste_a_m
steamed103712143steamed
steams84916903ste_ams
steamy115112373ste_amy
stearic939423ste_aric
stearin7312003ste_arin
steed66024943ste__ed
steeked124010473steeked
steeled83513223steeled
steelyard1342113steelyard
steeped103412283steeped
steer55423863ste_er_
steered83615253steered
steers63820983ste_ers
steeved113610133steeved
stela54019043stela__
stelae63716483stela_e
stelai63912563stela_i
stellar72610433stellar_
stemmed12278153stemmed
stemwares1444523stemwares
stepped123210053stepped
stere55328543ste__re
stern55319123ste__rn
sternwards1442613sternwards
steroid81314873steroid
stetted82610403stetted
stew77525463stew___
stewable1337133stewable
stewardess1442263stewardess
stewarding1543523stewarding
stewbum1442943stewbum
stewing113412493stewing
stewpan1234193stewpan
stewpans1343713stewpans
stews85519143stew__s
stewy116112063stew__y
stinkard1344323stinkard
stoneware1254293stoneware
stopword1444503stopword
stowage1136703stowage
stowed105817203stow_ed
strand74514823st_rand
strawed114813613strawed
strewed115811343strew_ed
strewer104310413strewer_
strewers11409063strewers
stylar9358113stylar_
sunwards1236443sunwards
swards105415133s__wards
sware85828213s__ware
swarf115324653s__warf
swarm106218843s__warm
swart86234643s__wart
swear85316853swe_ar_
swears94114073swe_ars
sword95214123s__word
tabard9313333_tabard
tear45242883_te_ar_
teared75722153_te_ared
tears55436463_te_ars
teary85124053_te_ary
teaware1048143_teaware
tetrad73612053_tetrad
tewed94718533_tew_ed
thwart12311683_thwart
towards1138783_towards
untoward1243193untoward
upward12147163_upward
vanward1456943vanward
vaward13498723_vaward
ward86542253___ward
wayward1736053wayward
westward1543823west_ward
wetware1335803wetware

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.406440125.6
2DLD Change Limit1340271976.17021722.4
3Display Results1971970.0633127.0
 (SQL Overall)1786911976.63926915.3
 
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.