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

91 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
miscasting155707(None) 
discanting1449452discanting
discasing1339432discas_ing
dismasting1446382dismasting
distasting1248022distasting
misacting1439082mis_acting
miscalling1547862miscalling
misciting1439672misc_iting
misclassing1644122misclassing
miscutting1576052miscutting
misdating131010662misda_ting
miseating121215432misea_ting
mismating141211822misma_ting
misparting1538082misparting
misrating121014852misra_ting
casting104628343___casting
descanting1446923descanting
discarding1547343discarding
discepting1658473discepting
discussing1445983discussing
diseasing11310833diseas_ing
disgusting1345963disgusting
disparting1438933disparting
disrating11714553disra_ting
impasting1436313_impasting
incanting1289903_incanting
incasing11610603_incas_ing
linecasting14102783linecasting
mascaraing1544253mascaraing
masting104325823m___asting
migrating13910533migra_ting
misadapting1743063misadapting
misadding14115833mis_adding
misaiming1437873mis_aiming
misassign1243223mis_assign
misbiasing1545203misbias_ing
misbiassing1642633misbiassing
miscaption1644763miscaption
miscaptions1744183miscaptions
miscarrying1942723miscarrying
miscast11312413miscast___
miscasts1238343miscast__s
mischarging2043713mischarging
misclaiming1844093misclaiming
miscoding1538183misc_oding
miscoining1597763miscoining
miscooking1945003miscooking
miscopying2044973miscopying
miscounting1646053miscounting
miscreating1648493miscreating
miscuing1338733misc__uing
misediting1446573misediting
misfitting1645533misfitting
misgauging1543903misgauging
misgrafting1844083misgrafting
mishitting1645993mishitting
mislaying1557913misla_ying
mislocating1645893misloca_ting
mismaking18118023misma_king
mismarking1955863mismarking
mismeeting1546243mismeeting
misnaming1447423misna_ming
mispaging1537803mispa_ging
mispainting1645293mispainting
misparsing1546613misparsing
misplanting1645623misplanting
misquoting2244363misquoting
misraising1348123misraising
misrouting1347223misrouting
missaying1537633missa_ying
misseating131310943misseating
missetting13107903missetting
missing103619073mis__s_ing
missorting1347123missorting
misstarting14125203misstarting
misstating13129313misstating
missuiting1356743missuiting
mistaking1699693mista_king
misting103623383mi___sting
mistrusting1465923mistrusting
mistrysting1774313mistrysting
misusing1138893mis_us_ing
misvaluing1684603misvaluing
miswriting1646843miswriting
precasting15169833precasting
recasting122414233_recasting
scanting113914763__scanting
scarting113415263__scarting
scatting113311813__scatting
upcasting1434823_upcasting
webcasting1842483webcasting

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603916.90620359.5
3Display Results91910.0461978.3
 (SQL Overall)178691917.10825139.4
 
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.