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

147 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
disparted133885(None) 
disported13310301disported
misparted1437261misparted
biparted1335132bi_parted
departed1238822d_eparted
disarmed1238642dis_armed
disbarred1345282disbarred
discanted1339332discanted
discarded1437082discarded
dismasted1346832dismasted
disparaged1545042disparaged
disparate1249052disparate_
dispart101115282dispart__
disparts11109952dispart_s
dispersed13119782dispersed
dispirited1445932dispirited
displanted14126632displanted
disputed1238352disp_uted
disrated10915572disra_ted
disserted11109812disserted
distasted1137962distasted
distorted1139372distorted
imparted13248062_imparted
misparsed1446252misparsed
comparted16338423comparted
crispated1445023crispa_ted
cuspated1335913cuspa_ted
darted84620923d___arted
departee1139733d_epartee
deported1249703d_eported
desalted1038313des_alted
descanted1336673descanted
deserted101012203des_erted
despaired1344503despaired
despited1248323desp_ited
diapaused1343093diapaused
diapered1238003diaper_ed
dictated1239203dicta_ted
dilated93115823di_la_ted
disabled1248713dis_abled
disagreed1245463disagreed
disarmer1138033dis_armer
disaster949943dis_aster
disbanded1445643disbanded
disbursed1365763disbursed
discalced1545653discalced
discard11310213discar__d
discarder1346753discarder
discased122510853disca_sed
discepted1547523discepted
discerned1347863discerned
discharged1864453discharged
discorded1438133discorded
disdained1246023disdained
diseased103011713disea_sed
disgorged1345263disgorged
disgraced1446743disgraced
disgusted1246123disgusted
dishearten1444333dishearten
disherited1546703disherited
disjected2086353disjected
dismantled1443693dismantled
dismayed1535743disma_yed
disparage1346203disparage
disparager1444393disparager
disparages1446043disparages
disparately1763183disparately
disparities1446793disparities
disparity1546393disparity
disparting1438933disparting
dispatch1654553dispa_tch
dispatched1993883dispatched
dispelled13117573dispelled
dispended14147823dispended
dispensed13158773dispensed
disperse111011353disperse_
disperser12109083disperser
disperses121211773disperses
displaced1546793displaced
displayed1645883displayed
disploded1446543disploded
displumed1544353displumed
disport101015953disport__
disports111111113disport_s
disposed12310943disp_osed
dispraised1446403dispraised
dispread1247103disp_read
disprized2247363disprized
disproved16147343disproved
dispute1039083disp_ute_
disputer1137973disp_uter
disputes1139653disp_utes
disrate81418523disra_te_
disrates91118153disra_tes
disrooted1147623disrooted
disrupted1345973disrupted
dissaved1337313dissa_ved
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserved14107003disserved
dissipated1446053dissipa_ted
distained1139603distained
distanced1348573distanced
distaste939943distaste_
distastes1039633distastes
distorter1048403distorter
distracted1448873distracted
disturbed13195583disturbed
disunited1177273disunited
disvalued1444193disvalued
diverted13199583di_verted
impacted15286353_impacted
imparked17264863_imparked
imparter12357543_imparter
impasted13297553_impasted
imported13308693_imported
misacted1338673mis_acted
misdated121211123misda_ted
mismarked1845243mismarked
mismated131111333misma_ted
mispaged1438243mispa_ged
mispainted1545013mispainted
misparse1237733misparse_
misparses1347653misparses
mispart111113783mispart__
misparts12108173mispart_s
misplanted1565443misplanted
misrated111315383misra_ted
missorted1247033missorted
misstarted1344873misstarted
parted94228683___parted
ramparted1443543ramparted
restarted10410053restarted
scarted104816123__scarted
smarted105012613__smarted
spared95427493__spar_ed
sparged113512763__sparged
sparked143513143__sparked
sparred104512863__sparred
spatted104014143__spatted
spirted103913073__spirted
sported104015433__sported
spurted103111973__spurted
started84217323__started
unparted11310823_unparted
upstarted1244213upstarted

Search took 10 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.453394461.4
2DLD Change Limit1486411478.75016987.5
3Display Results1471470.0801837.5
 (SQL Overall)1786911479.28319249.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.