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

106 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
disowned133643(None) 
discrowned1744022discrowned
disjoined1845832disjoined
disown1036952disown__
disowns1136732disown_s
downed115314782d__owned
drowned12419902d_rowned
browned134710973_browned
clowned13447723_clowned
crowned133912423_crowned
dawned113912093d__awned
deboned113411633debo_ned
decrowned1663653decrowned
dehorned1345683dehorned
deponed113712873depo_ned
designed1136943designed
desorbed1236433desorbed
destined103312453destined
dined76431993di___ned
dinned84317613di__nned
disabled1248713disabled
disarmed1238643disarmed
disavowed1743883disavow_ed
disband1138243disban_d
disbanded1445643disbanded
disbound1245853disboun_d
disbowel14115213disbow_el
disboweled1753123disboweled
discanted1339333discanted
discased122510853discased
disced104914653dis__ced
discerned1347863discerned
discoed11312483dis_coed
discorded1438133discorded
discounted1447843discounted
disdained1246023disdained
diseased103011713diseased
disgorged1345263disgorged
dished114318713dis__hed
disjointed1944833disjointed
disked125015763dis__ked
disliked14288553disliked
dislimned1344623dislimned
dislodged1344573dislodged
dismayed1535743dismayed
dismounted1445413dismounted
disobey1346243diso_bey
disobeyed1643463disobeyed
disorder1038123disorder
disowning1446113disowning
disownment16115823disownment
dispend11289413dispen_d
dispended14147823dispended
dispensed13158773dispensed
disported13310303disported
disposed12310943disposed
disputed1238353disputed
disrated10915573disrated
disrobed1238093disrobed
disrooted1147623disrooted
dissaved1337313dissaved
dissed85220183dis__sed
dissented1199723dissented
dissolved1445593dissolved
distained1139603distained
distanced1348573distanced
distend93312073disten_d
distended12157923distended
distorted1139373distorted
disused93211033dis_used
disyoked1745463disyoked
divined12329693di_vined
divorced1544313divorced
dizened18267333di_zened
donned85015743d__onned
dowed104632613d__ow_ed
downer104414923d__owner
dowsed115015013d__owsed
droned84616863d_ro_ned
drownd11478313d_rown_d
drownded14334433d_rownded
drowner11369803d_rowner
drowsed12448743d_rowsed
frowned14348833_frowned
gowned114410133__gowned
ironed74916013_iro_ned
listened9168813listened
masoned1039803maso_ned
miaowed1333883miaow_ed
miscoined1448443miscoined
misjoined1945453misjoined
mistuned1157723mistuned
owned95113233___owned
poisoned1136953poiso_ned
preowned1435213preowned
prisoned1138813priso_ned
renowned1235973renowned
resowed113712253resow_ed
sorned74820043__sorned
sowed94933863__sow_ed
ungowned1335183ungowned
unowned1148803_unowned
unsowed112511053unsow_ed
visioned1247013visioned
visored1138143viso_red
widowed1534843widow_ed

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.1561145455.1
2DLD Change Limit1461621068.42017358.9
3Display Results1061060.0502120.0
 (SQL Overall)1786911068.62620715.4
 
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.