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

136 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
storeyed123464(None) 
stereoed937882stereoed
stored75524212stor__ed
storey95217612storey__
storeys10559652storey_s
storied8515162stor_ied
stormed1039042stor_med
strayed114513282st_rayed
strewed115811342st_rewed
stroyed114110862st_royed
bogeyed1435673_bogeyed
boogeyed1543723boogeyed
cooeyed1346893_cooeyed
estrayed1236393est_rayed
forayed14368593_forayed
foureyed1543663foureyed
frogeyed1642783frogeyed
greyed114610603__greyed
honeyed1437773_honeyed
hoorayed1544013hoorayed
hoseyed1436953_hoseyed
moneyed1337493_moneyed
moseyed1336133_moseyed
obeyed1235823__obeyed
phoneyed1743843phoneyed
popeyed1535713_popeyed
preyed125313203__preyed
scorched16187193scorched
scored94621133scor__ed
scorepad1363383scorepad
scorned10229953scor_ned
screed95718933s_cre_ed
screwed135710663s_crewed
secreted1138633secreted
shored105723653shor__ed
shorted113614403shor_ted
shortened1345663shortened
shoveled15195353shoveled
showered1537013showered
shrewed14589853s_hrewed
snored74819543snor__ed
snorkeled1442883snorkeled
snorted83813493snor_ted
sobered102912433s_obered
sorbed94916523s_or_bed
sored66141783s_or__ed
sorehead1246973s_orehead
sorned74820043s_or_ned
sorted74523713s_or_ted
sortied83314103s_ortied
spored94821793spor__ed
sported104015433spor_ted
sprayed13398903s_prayed
stamened1137633stamened
starched14199313starched
stared75429873star__ed
starred85013453star_red
started84217323star_ted
startled9208563startled
starved114911573star_ved
stayed104817273st__ayed
steed66024943st__e_ed
steeked124010473st_eeked
steeled83513223st_eeled
steeped103412283st_eeped
steered83615253st_eered
steeved113610133st_eeved
stewed104814243st__ewed
stirred8359703stir_red
stobbed12287493sto_bbed
stocked144312873sto_cked
stodged10377983sto_dged
stogey105811543stogey__
stogeys11486123stogey_s
stoked114718293sto__ked
stoled74521593sto__led
stomped124110533sto_mped
stoned75923143sto__ned
stoney96217353stoney__
stooged94310733sto_oged
stooked124312303sto_oked
stooled84313893sto_oled
stooped103813833sto_oped
stoped94721013sto__ped
stopped124512203sto_pped
stoppered1444473stoppered
stoppled1345003stoppled
storage8310473storage_
storages9311103storages
storaxes1536883storaxes
store56333813stor__e_
storer64721673stor__er
storers75018683store_rs
stores65533663stor__es
storewide1343093storewide
stories7324273stor_ies
stormier1036103stormier
stormy115510733stormy__
story86723033stor_y__
stotted83511423sto_tted
stounded10276213stounded
stoutened1053573stoutened
stowed105817203sto__wed
strafed114413333st_rafed
straked125415343st_raked
strawed114813613st_rawed
strayer104312503st_rayer
streaked13228453st_reaked
streamed11258903st_reamed
streek104111413st_re_ek
streeked13246153streeked
streel64214023st_re_el
streeled9267873streeled
street64125773st_re_et
stressed9128543st_ressed
strewer104310413st_rewer
striped105214363st_riped
strived114713663st_rived
stroked124613623st_roked
strolled937823strolled
stropped1367343stropped
strowed115312143st_rowed
stroyer103510783st_royer
sturdied10215963sturdied
styed95815483st___yed
styrene10116693styrene_
styrenes11116623styrenes
surveyed1544233surveyed
tokened1236393_tokened
torched133511353_torched
torqued17224893_torqued
tourneyed1342323_tourneyed
toweled112410223_toweled
towered112911403_towered
toyed96019803_to__yed
treed65626733_t_re_ed

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.436409841.7
2DLD Change Limit1461621366.86021306.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.34224338.2
 
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.