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

81 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
miscount129947(None) 
discount11811311discount
miscounts1386411miscounts
viscount1396781viscount
discounts1287822discounts
dismount1188222dismount
misbound1344932misbound
miscoin11311432miscoin_
miscoins12311082miscoins
miscounted1546062miscounted
miscut10614822misc_u_t
misdoubt1394072misdoubt
mispoint121012362mispoint
missound1145112missound
missout9412662missou_t
viscounts1484582viscounts
viscounty1793402viscounty
account11109043_account
biscuit1147373bisc_uit
count74932053___count
disbound1245853disbound
discant103017263disc_ant
discoing12511453discoing
discounted1447843discounted
discounter1347023discounter
disjoint1649233disjoint
dismounts1275283dismounts
mascon103612743masco_n_
mascons113411583masco_ns
mascot104016073masco__t
mesclun1144013mesclun_
mescluns1243343mescluns
midcult1246303midc_ult
midpoint13117493midpoint
misagent11410723misagent
miscast11312423misc_ast
miscode12310413misco_de
miscoded1437983miscoded
miscodes13310423miscodes
miscoding1538183miscoding
miscoined1448443miscoined
miscolor1245603miscolor
misconduct1753013misconduct
misconnect1654403misconnect
miscook1546473misco_ok
miscooks1645463miscooks
miscopy1636663misco_py
miscounting1646053miscounting
miscreant1347573miscreant
miscue10412223misc_u_e
miscued1239293misc_ued
miscues11312393misc_ues
miscuing1338733miscuing
miscuts1139183misc_uts
misdoing1238803misdoing
misdone10310863misdo_ne
misdoubts1482503misdoubts
misevent1349223misevent
misjoin1637693misjoin_
misjoins1736913misjoins
mispaint121111893mispaint
misplant12410763misplant
mispoints13106633mispoints
misprint12912973misprint
misroute1049103misroute
missent94318713mis_sent
missort9314653misso_rt
missounds1243533missounds
missouts1037623missouts
misspent1259173misspent
missuit9911303mis_suit
mistouch1543803mistouch
mistrust1049203mistrust
mistune9310653mis_tune
mount74128063m___ount
outcount1049143outcount
recount9315173_recount
rediscount1353533rediscount
scout75031453__scou_t
viscountcy2091953viscountcy
viscous1238833viscou_s

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 Filter1786911461620.420425454.8
2DLD Change Limit146162816.81321453.4
3Display Results81810.0332454.5
 (SQL Overall)178691817.26624592.8
 
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.