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 “dismaying” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
dismaying165682(None) 
discasing1339432discasing
diseasing11310832diseasing
dismasting1446382dismasting
dismayingly2152172dismayingly
displaying1746312displaying
disrating11714552disrating
dissaving1436952dissaving
mislaying1557912mislaying
mismaking18118022mismaking
mismating141211822mismating
missaying1537632missaying
assaying1236003_assaying
damaging1337383d_amaging
decaying15239453d_ecaying
deejaying2142753deejaying
defraying1735853defraying
delaying133210973d_elaying
descrying1635103descrying
dialing94318173di__aling
dictating1338883dictating
dilating102714903di_lating
dimming13339593di_m_ming
dimpling14199023di_mpling
dirtying1336093di_rtying
disabling1337753disabling
disarming1338803disarming
disarraying1644053disarraying
disbanding1545583disbanding
disbarring1445283disbarring
discanting1449453discanting
discarding1547343discarding
discing113914593dis__cing
discoing12511453dis_coing
disdain938513disda_in_
disdaining1345993disdaining
disdains1037913disda_ins
disgracing1586743disgracing
dishing124017103dis__hing
disking134615493dis__king
disliking1537313disliking
dismantling1543393dismantling
dismay12229473dismay___
dismayed1535743dismay_ed
dismays13237433dismay__s
dismissing1445063dismissing
disobeying1743803disobeying
disowning1446113disowning
disparting1438933disparting
displacing1646413displacing
disposing1339933disposing
disputing1337763disputing
disrobing1347703disrobing
disseating121111783disseating
dissing94517683dis__sing
dissuading1345723dissuading
distain8313783dista_in_
distaining1248903distaining
distains9413603dista_ins
distancing1447083distancing
distasting1248023distasting
disusing1039003dis_using
disvaluing1574433disvaluing
disyoking1844993disyoking
divvying1932773di_vvying
dizzying2133023di_zzying
doomsaying1751503doomsaying
draying123813843d__raying
dummying17263723d_ummying
essaying1235033_essaying
imaging1138083_i_maging
inlaying1247893_inlaying
jimmying2342383ji_mmying
maying124421153___maying
misdating131010663misdating
miseating121215433miseating
mislying1437843mis_lying
mismarking1955863mismarking
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
misplaying1845553misplaying
misrating121014853misrating
mistaking1699693mistaking
resaying122512453res_aying
sashaying1644593sashaying
saying104325543__s_aying
slaying113316843__slaying
spaying133014623__spaying
staying114017323__staying
swaying143610643__swaying
unsaying1288153uns_aying
visaing11279333vis_a_ing

Search took 8 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.420425454.8
2DLD Change Limit148641936.98321286.1
3Display Results93930.0332818.2
 (SQL Overall)178691937.43624030.5
 
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.