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

88 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
distasting124802(None) 
dismasting1446381dismasting
dictating1338882dicta_ting
discanting1449452discanting
discasing1339432discas_ing
diseasing11310832diseas_ing
disgusting1345962disgusting
disparting1438932disparting
disrating11714552disra_ting
distaining1248902distaining
distancing1447082distancing
distorting1239582distorting
distracting1569252distracting
distrusting1386492distrusting
miscasting1557072miscasting
demasting1338453d_emasting
desalting1138843des_alting
descanting1446923descanting
desisting112810383des_isting
destaining1267943destaining
detesting112610323d_etesting
digesting12208673di_gesting
dilating102714903di_la_ting
disabling1337753dis_abling
disarming1338803dis_arming
disbanding1545583disbanding
disbarring1445283disbarring
discarding1547343discarding
discepting1658473discepting
discussing1445983discussing
disdaining1345993disdaining
disjecting2177243disjecting
dismantling1543393dismantling
dismaying1656823disma_ying
dismissing1445063dismissing
displanting1546043displanting
disporting1439823disporting
disposing1339933dispos_ing
disputing1337763dis_puting
disrooting1247743disrooting
disrupting1446343disrupting
dissaving1436953dissa_ving
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserting121310853disserting
dissing94517683dis__s_ing
distain8313783dista__in_
distains9413603dista__ins
distaste939943distast__e
distasted1137963distast_ed
distastes1039633distast_es
distending1348333distending
distilling1247793distilling
distraining1346983distraining
distressing1385973distressing
districting1559003districting
disturbing1445653disturbing
disuniting1247403disuniting
disusing1039003dis_us_ing
disvaluing1574433disvaluing
divesting14298483di_vesting
estating92614993_esta_ting
gestating11229983gesta_ting
impasting1436313_impasting
instating10812213insta_ting
misacting1439083mis_acting
misdating131010663misda_ting
miseating121215433misea_ting
mismating141211823misma_ting
misparting1538083misparting
misrating121014853misra_ting
misstarting14125203misstarting
misstating13129313missta_ting
mistaking1699693mista_king
mistrusting1465923mistrusting
mistrysting1774313mistrysting
nictating1237573nicta_ting
pretasting13239283pretasting
restarting11310663restarting
restating102319413resta_ting
retasting102513413_retasting
starting93116173__starting
stashing123511583__stashing
stating83725163__sta_ting
tasting84624213___tasting
unstating10711213unsta_ting
upstarting1343883upstarting

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.1561145455.1
2DLD Change Limit140603886.54621479.2
3Display Results88880.0461913.0
 (SQL Overall)178691886.74826480.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.