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

136 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
misciting143967(None) 
inciting11312532_inciting
misacting1439082misacting
misaiming1437872misaiming
miscasting1557072miscasting
miscoding1538182miscoding
miscoining1597762miscoining
miscuing1338732misc_uing
miscutting1576052miscutting
misdating131010662misdating
miseating121215432miseating
misediting1446572misediting
misfiling1537222misfiling
misfiring1536972misfiring
misfitting1645532misfitting
misgiving1645592misgiving
mishitting1645992mishitting
misliking1637112misliking
misliving1546982misliving
mismating141211822mismating
misrating121014852misrating
missuiting1356742missuiting
mistiming1438912mistiming
misting103623382mis__ting
mistitling1346222mistitling
miswriting1646842miswriting
visiting1238392vis_iting
abscising1444943abscising
bisecting1436973bisecting
circuiting1545363circuiting
citing94220183___citing
despiting13179323despiting
discanting1449453discanting
discasing1339433discasing
discepting1658473discepting
discing113914593disc__ing
discipling1645873discipling
discoing12511453disc_oing
disliking1537313disliking
disputing1337763disputing
disrating11714553disrating
disuniting1247403disuniting
eliciting1237773eliciting
escoting1158713_escoting
exciting1838023_exciting
fisting113818123fis__ting
histing113720373his__ting
igniting1037363_igniting
incising11411093_incising
inditing10312113_inditing
inviting1239733_inviting
lichting14268513li_chting
limiting1138813li_miting
listing84020593lis__ting
masting104325823mas__ting
meriting11314683m_eriting
miching152911803mi_c_hing
midwifing1942963midwifing
midwiving1942623midwiving
migrating13910533migrating
milting103619123mi__lting
mimicking2043873mimicking
mincing123314333minc__ing
minting103020813mi__nting
minuting1139723mi_nuting
misadding14115833misadding
misbiasing1545203misbiasing
misbilling1545543misbilling
misbinding1645063misbinding
miscalling1547863miscalling
miscite11314383miscit__e
miscited13310423miscit_ed
miscites12313783miscit_es
misclaiming1844093misclaiming
miscoin11311433misc_oin_
miscoins12311083misc_oins
miscooking1945003miscooking
miscopying2044973miscopying
miscounting1646053miscounting
miscreating1648493miscreating
misdialing1446263misdialing
misdoing1238803mis_doing
misdriving1745163misdriving
misgivings1742413misgivings
misguiding1544343misguiding
misjoining2085293misjoining
miskicking1844243miskicking
mislaying1557913mislaying
mislighting1843413mislighting
mislocating1645893mislocating
mislying1437843mis_lying
mismaking18118023mismaking
mismeeting1546243mismeeting
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
mispainting1645293mispainting
misparting1538083misparting
mispointing1645793mispointing
mispoising1546583mispoising
mispricing1746713mispricing
misprinting1646823misprinting
misprizing2447533misprizing
misquoting2244363misquoting
misraising1348123misraising
misrouting1347223misrouting
misruling1237493misruling
missaying1537633missaying
misseating131310943misseating
missetting13107903missetting
missing103619073mis__sing
missioning1347403missioning
missorting1347123missorting
misstating13129313misstating
mistaking1699693mistaking
mistuning1237673mistuning
mistyping1744723mistyping
misusing1138893mis_using
misyoking1944923misyoking
mulcting13246983mulc_ting
muscling1337853musc_ling
musicking1844513musicking
musting103221073mus__ting
picoting1338883pi_coting
positing11312303pos_iting
reciting113118073_reciting
reinciting1347103reinciting
resiting93521123res_iting
respiting121912863respiting
siting74126623__s_iting
skiting123812503__skiting
smiting103014443__smiting
spiting103917623__spiting
suiting83419003__suiting
tincting1148883tinc_ting
wisting113519743wis__ting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411366.33023482.0
3Display Results1361360.0602266.7
 (SQL Overall)1786911366.81326227.9
 
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.