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 “disarmed” 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
disarmed123864(None) 
disarmer1138031disarmer
disabled1248712disabled
disagreed1245462disagreed
disarm9310472disarm__
disarmers1246942disarmers
disarms1039042disarm_s
disbarred1345282disbarred
discarded1437082discarded
disparted1338852disparted
disrated10915572disrated
gisarme1044172gisarme_
gisarmes1144432gisarmes
inarmed10268672_inarmed
misaimed1338092misaimed
alarmed1037743_alarmed
armed86324433___armed
beswarmed1743083beswarmed
biformed1643693biformed
biparted1335133biparted
bistred103311853bistr_ed
charmed154714253_charmed
dammed124214793d__ammed
dared75935013d__ar_ed
darked123919633d__arked
darned85018483d__arned
darted84620923d__arted
debarked16175833debarked
debarred12165643debarred
defamed14309833defa_med
deformed15248263deformed
degermed1335453degermed
demarked16187223demarked
departed1238823departed
depermed1436453depermed
desalted1038313desalted
desanded11227453desanded
descried1248083descried
deserted101012203deserted
deserved13108133deserved
desired9311983desir_ed
desorbed1236443desorbed
dewormed15236223dewormed
diademed1344153diademed
diagramed1454453diagramed
dialed84716453di_a_led
dialled9510133di_alled
diaries83321953di_aries
dilated93115823dila_ted
dimmed124110323di__mmed
dirked124912273di__rked
dirled84514903di__rled
disable10516433disable_
disabler1147913disabler
disables11410903disables
disabused1344903disabused
disaffirmed2151553disaffirmed
disagree1048353disagree
disagrees1146403disagrees
disarming1338803disarming
disarray1244833disarray
disarrayed1543293disarrayed
disaster949943disaster
disavowed1743883disavowed
disbanded1445643disbanded
disbarment1546653disbarment
disbursed1365763disbursed
discalced1545653discalced
discanted1339333discanted
discard11310213discar__d
discarder1346753discarder
discased122510853discased
disced104914653dis__ced
discerned1347863discerned
discharged1864453discharged
disclaimed1644413disclaimed
discoed11312483dis_coed
discorded1438133discorded
discreet11413183discreet
disdained1246023disdained
diseased103011713diseased
disgorged1345263disgorged
disgraced1446743disgraced
dished114318713dis__hed
dishelmed1645093dishelmed
disked125015763dis__ked
disliked14288553disliked
dislimned1344623dislimned
dismasted1346833dismasted
dismayed1535743dismayed
disme85716243dis__me_
dismes95617673dis__mes
disorder1038133disorder
disowned1336433disowned
disparaged1545043disparaged
dispersed13119783dispersed
displumed1544353displumed
disported13310303disported
disposed12310943disposed
dispread1247103dispread
disprized2247363disprized
disproved16147343disproved
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
disrobed1238093disrobed
dissaved1337313dissaved
dissed85220183dis__sed
disserted11109813disserted
disserved14107003disserved
distained1139603distained
distanced1348573distanced
distasted1137963distasted
distome10313233distome_
distomes11314163distomes
distorted1139373distorted
disturbed13195583disturbed
disused93211033dis_used
disvalued1444193disvalued
disyoked1745463disyoked
diverged14256883diverged
diverted13199583diverted
divorced1544313divorced
drammed13378073d_rammed
dreamed114310633drea_med
dwarfed1533483d_warfed
farmed125117653__farmed
firearmed1544043firearmed
firmed125411883fi__rmed
harmed125218833__harmed
misacted1338673misacted
misadded1335753misadded
misformed1745243misformed
misframed1745623misframed
mismarked1845243mismarked
misnamed13127593misnamed
misparsed1446253misparsed
misparted1437263misparted
misrated111315383misrated
mistermed1438363mistermed
mistimed1339123mistimed
prearmed1397993prearmed
psalmed1234503_psalmed
rearmed103912823_rearmed
rewarmed14257433rewarmed
swarmed1367483_swarmed
tiaraed837053ti_araed
unarmed101811923_unarmed
unharmed1438093unharmed
unwarmed1437303unwarmed
visaed104110503visa__ed
visaged1235683visa_ged
visard103910123visar__d
visored1138143visor_ed
vizarded2242753vizarded
warmed124516893__warmed

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.436409841.7
2DLD Change Limit1461621567.84318636.0
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.34221420.6
 
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.