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

87 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
miswords144660(None) 
misword1338411misword_
discords1238592discords
milords10117852mi_lords
misawards1563792misawards
misforms1545892misforms
missorts1038322missorts
misworded1644232misworded
swords104510802__swords
bistorts10118813bistorts
bywords1634283_bywords
cissoids1145363cissoids
cusswords1542643cusswords
discards1238913discards
discoids1239873discoids
discord1139993discord_
disports111111113disports
distorts91112353distorts
figworts1544683figworts
fiords10498623fi__ords
fishworms2043253fishworms
gasworks1645943gasworks
inwards1138343_inwards
keywords1944323keywords
madworts1456173madworts
manwards1447613manwards
mastoids1177873mastoids
meshworks2143633meshworks
milkwoods1943383milkwoods
milkworts1843443milkworts
millworks1845093millworks
milord999573mi_lord_
minors85117103mi_nor_s
mirrors938623mirror_s
misadds1136303mis_adds
misaward1464593misaward_
misbinds1345163misbinds
miscode12310413misco_de
miscodes13310423miscodes
miscoins12311083miscoins
miscooks1645463miscooks
misdeeds12276813misdeeds
misdoers1137103misdoers
misdoes10312493misdo_es
misers85025703mis_er_s
misfeeds14315623misfeeds
misfires132210583misfires
misfocus1543453misfocus
misform1437513misfor_m
misgrows1444963misgrows
misjoins1736913misjoins
misleads11358543misleads
mismarks1645893mismarks
mismoves1537293mismoves
misorder1147283mis_order
misorders1245883mis_orders
misos76523293mis_o__s
misparts12108173misparts
misreads11268923misreads
misrecords1552913misrecords
missends11368233missends
missort9314653missor_t
missounds1243533missounds
missouts1037623missouts
mistends11419593mistends
misterms123711353misterms
misters93927513mister_s
miswording1744863miswording
miswrit1249413misw_rit
miswrote1346183miswrote
misyokes1735513misyokes
mugworts1443443mugworts
mustards11297883mustards
nonwords1247463nonwords
passwords1544183passwords
pinworks17106353pinworks
pinworms15115783pinworms
rewords115413983_rewords
ribworts1345093ribworts
ripcords1344073ripcords
sords64527803__s_ords
swards105415133__swards
sword95214123__sword_
tinworks1596043tinworks
visards11328153vis_ards
visors92912223vis_or_s
words95425073___words

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 Filter1786911461620.423422437.4
2DLD Change Limit146162876.28023274.2
3Display Results87870.0332636.4
 (SQL Overall)178691876.73626527.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.