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

109 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
disporting143982(None) 
disparting1438931disparting
distorting1239581distorting
deporting1369592d_eporting
discording1547662discording
disgorging1455012disgorging
dispersing1449302dispersing
dispiriting1545942dispiriting
disposing1339932dispo_sing
disproving1746292disproving
disputing1337762disp_uting
disrooting1247742disrooting
disserting121310852disserting
importing1438192_importing
misparting1538082misparting
missorting1347122missorting
sporting112415462__sporting
assorting1037303_assorting
comporting17199163comporting
dehorting1447213d_ehorting
departing1349513d_eparting
deserting11713143des_erting
desorbing1346363des_orbing
despiting13179323desp_iting
despoiling1445113despoiling
desponding1555663desponding
diapering1339033diaper_ing
disarming1338803dis_arming
disbarring1445283disbarring
disbursing1445373disbursing
discanting1449453discanting
discarding1547343discarding
discepting1658473discepting
discerning1447863discerning
discoing12511453disco__ing
discounting1547443discounting
discoursing1544853discoursing
disgusting1345963disgusting
disheriting1646453disheriting
disjecting2177243disjecting
disjoining1965723disjoining
disjointing2045293disjointing
dislocating1546733dislocating
dislodging1444403dislodging
dismasting1446383dismasting
dismounting1545083dismounting
disowning1446113dis_owning
disparaging1644723disparaging
dispelling1447613dispelling
dispending1547923dispending
dispensing1448233dispensing
dispeopling1743283dispeopling
displacing1646413displacing
displanting1546043displanting
displaying1746313displaying
disploding1575873disploding
displuming1644373displuming
disport101015953disport___
disported13310303disport_ed
disportment1656653disportment
disports111111113disport__s
disprizing2347923disprizing
disrating11714553dis_rating
disrobing1347703disro_bing
disrupting1446343disrupting
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
dissolving1545113dissolving
distasting1248023distasting
distortion1146693distortion
distortions1246613distortions
disturbing1445653disturbing
disuniting1247403disuniting
disyoking1844993disyo_king
diverting142410333di_verting
divorcing1644323di_vorcing
escorting1237713_escorting
exporting1937323_exporting
imparting1437243_imparting
imposting1436813_imposting
intorting10311413_intorting
misforming1845403misforming
misparsing1546613misparsing
mispointing1645793mispointing
mispoising1546583mispoising
misreporting1753233misreporting
misrouting1347223misrouting
miswording1744863miswording
nonsporting1444823nonsporting
porting103021783___porting
purporting1543793purporting
reimporting1644093reimporting
reporting12513903_reporting
resorting10614613res_orting
respotting1347113respotting
riposting1236063ri_posting
ripsnorting1451533ripsnorting
shorting122514803__shorting
snorting92613373__snorting
sorting83221813__s_orting
spirting112913633__spirting
sporing104319413__spor_ing
spotting112812093__spotting
spouting113511953__spouting
spurting113111633__spurting
supporting1545563supporting
visoring1238373vis_or_ing

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031096.39022003.6
3Display Results1091090.0631730.2
 (SQL Overall)1786911096.85926052.0
 
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.