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

156 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
preowned143521(None) 
browned134710972br_owned
crowned133912442cr_owned
drowned12419902dr_owned
frowned14348832fr_owned
prawned1346742pr_awned
preened103214992pre_ened
prowled13309912pr_owled
renowned1235982_renowned
aproned10311503apr_o_ned
arrowed1148133arrow_ed
brewed125411873bre_w_ed
browed125216403br_ow_ed
browner124911643br_owner
browsed134511243br_owsed
clowned13447733_clowned
crewed125316563cre_w_ed
crooned103813353cr_ooned
crowded14418803cr_owded
crowed124717313cr_ow_ed
crowner124012603cr_owner
crownet123714113cr_ownet
disowned1336433disowned
downed115314783__downed
droned84616863dr_o_ned
drownd11478313dr_own_d
drownded14334433dr_ownded
drowner11369803dr_owner
drowsed12448753dr_owsed
frowner13429683fr_owner
gowned114410133__gowned
greened93111263gre_ened
groaned9259973gr_oaned
groined92710813gr_oined
growled12278173gr_owled
ironed74916013ir_o_ned
meowed12148003_meow_ed
neoned7311493_neo_ned
owned95113233___owned
pardoned12189333pardo_ned
pawned124513283p__awned
peened94318163p_e_ened
peined94918843p_e_ined
penned94217613p_e_nned
peones83821043p_eo_nes
peopled1238513p_eopled
phoned124014553p_ho_ned
plowed124213203p_low_ed
prawner1246803pr_awner
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
prearmed1397993prearmed
prebaked1737173prebaked
prebend12319443preben_d
prebind123810643prebin_d
preboiled1455783preboiled
prebooked1863913prebooked
prebound1345893preboun_d
preceded1438293preceded
precented14310693precented
precised133213413precised
precited133013813precited
precoded1438863precoded
precooked1844993precooked
precooled1446363precooled
precured1339993precured
predated12513273predated
predried12309573predried
preed85128123pre___ed
preener93114833pre_ener
prefaced1638423prefaced
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
preformed17176203preformed
prefund1335733prefun_d
prefunded1644693prefunded
preloaded1335923preloaded
preluded1236473preluded
premed114617763pre__med
premised133013193premised
premixed20338013premixed
premolded1544683premolded
premune1138933premune_
preorder1136463preorder
prepared132210873prepared
prepaved16177233prepaved
prepped11329903pre_pped
prerinsed1246323prerinsed
presaged1238813presaged
presented12311633presented
preshowed1875183preshow_ed
presided12410553presided
presoaked1635653presoaked
presolved1545273presolved
presorted1239453presorted
pressed103317313pre_ssed
presumed1337973presumed
pretaped13339133pretaped
pretend104011013preten_d
pretended1337193pretended
prettied1159253prettied
pretyped16306123pretyped
prevented1539003prevented
prevised143611073prevised
prevued1337143pre_vued
prewarned1594773prewarned
prewired14358473prewired
preworked1954653preworked
preyed125313203pre__yed
prisoned1138813prisoned
probed114114823pr_o_bed
proceed12310553pr_oceed
prodded1257733pr_odded
profaned14207973profaned
progged12409803pr_ogged
promoed12310083pr_omoed
prone75332623pr_o_ne_
pronged113912393pr_onged
proofed13138723pr_oofed
propend123311273pr_opend
propined133111513propined
proponed132412043proponed
propped113311963pr_opped
prosed94921103pr_o_sed
protend104012793pr_otend
proved125016033pr_o_ved
prower114218123pr_ow_er
prowler123310013pr_owler
pruned93413113pr__uned
purloined1243703purloined
recaned102817203_recaned
recoined113614433_recoined
reconned113610663_reconned
recrowned1564863_recrowned
redonned10297103_redonned
refined114720003_refined
reigned949213_reigned
reined74425523_re_ined
rejoined16318593_rejoined
relined85321933_relined
reloaned939723_reloaned
reoiled84316853_reoiled
reopened1138523_reopened
repined104918773_repined
resined84522653_resined
resowed113712263_resow_ed
retuned86613973_retuned
rewed95425453_re_w_ed
rezoned173611163_rezoned
rowed94034323_r_ow_ed
trowed104714653tr_ow_ed
ungowned1335183ungowned
unowned1148813_unowned

Search took 9 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.420425454.8
2DLD Change Limit1461621567.83018666.9
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.31321495.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.