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

142 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
disported1331030(None) 
disparted1338851disparted
distorted1139371distorted
deported1249702d_eported
discorded1438132discorded
disgorged1345262disgorged
dispersed13119782dispersed
dispirited1445932dispirited
disport101015952disport__
disports111111112disport_s
disposed12310942dispo_sed
disproved16147342disproved
disputed1238352disp_uted
disrooted1147622disrooted
disserted11109812disserted
distorter1048402distorter
imported13308692_imported
misparted1437262misparted
missorted1247032missorted
sported104015432__sported
assorted956603_assorted
biparted1335133bi_parted
comported16319533comported
dehorted1357303d_ehorted
departed1238823d_eparted
deportee11510353d_eportee
deporter1169393d_eporter
deserted101012203des_erted
desorbed1236443des_orbed
despited1248323desp_ited
despoiled1344653despoiled
desponded1445323desponded
diapered1238003diaper_ed
diaspore1166063diaspor_e_
diaspores1266543diaspor_es
disagreed1245463disagreed
disarmed1238643dis_armed
disbarred1345273disbarred
disbursed1365763disbursed
discanted1339333discanted
discarded1437083discarded
discepted1547523discepted
discerned1347863discerned
discoed11312483disco__ed
discord1139993discor__d
discounted1447843discounted
discoursed1445793discoursed
disgorge1145733disgorge_
disgorges1245853disgorges
disgusted1246123disgusted
disherited1546703disherited
disjected2086353disjected
disjoined1845833disjoined
disjointed1944833disjointed
dislocated1497523dislocated
dislodged1344573dislodged
dismasted1346833dismasted
dismounted1445413dismounted
disorder1038133dis_order
disowned1336433dis_owned
disparaged1545043disparaged
disparate1249053disparate_
dispart101115283dispart__
disparts11109953dispart_s
dispelled13117563dispelled
dispended14147823dispended
dispensed13158773dispensed
dispeopled16143823dispeopled
disperse111011353disperse_
disperser12109083disperser
disperses121211773disperses
displaced1546793displaced
displanted14126633displanted
displayed1645883displayed
disploded1446543disploded
displumed1544353displumed
disporting1439823disporting
disportment1656653disportment
dispose10312763dispo_se_
disposer11310413dispo_ser
disposes11313823dispo_ses
dispread1247103disp_read
disprized2247363disprized
disprove14138193disprove_
disproven15146473disproven
disprover15137073disprover
disproves15158513disproves
dispute1039083disp_ute_
disputer1137973disp_uter
disputes1139653disp_utes
disrated10915573dis_rated
disrobed1238093disro_bed
disrupted1345973disrupted
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserved14107003disserved
dissolved1445593dissolved
distasted1137963distasted
distort81120333distort__
distorters1147163distorters
distorts91112353distort_s
disturbed13195583disturbed
disunited1177273disunited
disyoked1745463disyo_ked
diverted13199583di_verted
divorced1544313di_vorced
escorted1136703_escorted
exported1837133_exported
historied1347773historied
imparted13248063_imparted
importer12308913_importer
imposted13257403_imposted
intorted9310123_intorted
misformed1745243misformed
misparsed1446253misparsed
mispointed1545573mispointed
mispoised1446803mispoised
misreported1653173misreported
misrouted1247303misrouted
misworded1644233misworded
ported94223243___ported
purported1443463purported
reimported1543783reimported
reported11312703_reported
resorted9313493res_orted
respotted1235953respotted
riposted11216933ri_posted
shorted113614403__shorted
snorted83813493__snorted
sorted74523713__s_orted
spirted103913073__spirted
spored94821793__spor_ed
sporter93616553__sporter
spotted103713143__spotted
spouted103412263__spouted
spurted103111973__spurted
supported1444683supported
undistorted1353063undistorted
unsorted9312513uns_orted
unspotted1244933unspotted
visored1138143vis_or_ed

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411426.12624264.0
3Display Results1421420.0632254.0
 (SQL Overall)1786911426.62526972.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.