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 “dismayed” 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
dismayed153574(None) 
discased122510852discased
diseased103011712diseased
dismaler1137902dismaler
dismasted1346832dismasted
dismay12229472dismay__
dismays13237432dismay_s
displayed1645882displayed
disrated10915572disrated
dissaved1337312dissaved
mismated131111332mismated
undismayed1741772undismayed
assayed1135593_assayed
damaged1257453d_amaged
decayed14309333d_ecayed
deejayed2042443deejayed
defrayed1635403defrayed
delayed123310763d_elayed
dialed84716453di__aled
dictated1239203dictated
diemaker1545593diemaker
dilated93115823di_lated
dimmed124110323di_m_med
dimpled132810303di_mpled
disabled1248713disabled
disarmed1238643disarmed
disarrayed1543293disarrayed
disband1138243disba_nd
disbanded1445643disbanded
disbarred1345273disbarred
discalced1545653discalced
discanted1339333discanted
discard11310213disca_rd
discarded1437083discarded
discase102912863discase_
discases112014503discases
disced104914653dis__ced
discoed11312483dis_coed
disdained1246023disdained
disease83213843disease_
diseases92415813diseases
disgraced1446743disgraced
dished114318713dis__hed
disked125015763dis__ked
disliked14288553disliked
dismal92412243disma__l
dismalest1246313dismalest
dismally1446513dismally
dismals102010243disma_ls
dismantled1443693dismantled
dismast10311233disma_st
dismasts1137513dismasts
dismaying1656823dismaying
disme85716243dism__e_
dismes95617673dism__es
dismissed1344613dismissed
disobeyed1643463disobeyed
disowned1336433disowned
disparted1338853disparted
displaced1546793displaced
displayer1545833displayer
disposed12310943disposed
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
disrobed1238093disrobed
dissave1139413dissave_
dissaves1239413dissaves
disseated11711083disseated
dissed85220183dis__sed
dissuaded1265433dissuaded
distained1139603distained
distanced1348573distanced
distasted1137963distasted
distaves12311403distaves
disused93211033dis_used
disvalued1444193disvalued
disyoked1745463disyoked
drayed115911393d__rayed
essayed1134013_essayed
imaged1097763_i_maged
mayed115522403___mayed
misdated121211123misdated
mislayer1337503mislayer
mismade12129353mismade_
mismake15139373mismake_
mismakes16129883mismakes
mismarked1845243mismarked
mismate111415353mismate_
mismates121114563mismates
mismoved1635653mismoved
misnamed13127593misnamed
mispaged1438243mispaged
misplayed1745303misplayed
misrated111315383misrated
sashayed1543553sashayed
sayed96127143__s_ayed
slayed104716223__slayed
spayed124213613__spayed
stayed104817273__stayed
swayed133510263__swayed
unstayed12168393unstayed
unswayed15155713unswayed
visaed104110503vis_a_ed
visaged1235683vis_aged
vistaed1138023vista_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 Filter1786911461620.403443402.0
2DLD Change Limit1461621066.20323563.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.65226862.7
 
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.