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

104 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
misfiring153697(None) 
misfiling1537221misfiling
misaiming1437872misaiming
misciting1439672misciting
misfitting1645532misfitting
misforming1845402misforming
misgiving1645592misgiving
misliking1637112misliking
misliving1546982misliving
mistiming1438912mistiming
aspiring1138873_aspiring
desiring10312143des_iring
differing1746473differing
disfiguring1752483disfiguring
disliking1537313disliking
firing104021723___firing
fissuring1344813fissuring
impairing1445473impairing
infirming1545163_infirming
infixing1936103_infixing
inspiring1246183inspiring
mastering122315303mastering
midwifing1942963midwifing
midwiving1942623midwiving
miffing16298403mi_f_fing
minifying1845823minifying
minoring11311473mi_noring
miring93723803m___iring
mirroring1246193mirroring
misacting1439083misacting
misadding14115833misadding
misbiasing1545203misbiasing
misbilling1545543misbilling
misbinding1645063misbinding
miscoding1538183miscoding
miscoining1597763miscoining
miscuing1338733mis_cuing
misdating131010663misdating
misdefining1843313misdefining
misdialing1446263misdialing
misdoing1238803mis_doing
misdriving1745163misdriving
miseating121215433miseating
misediting1446573misediting
misfeeding1744993misfeeding
misfielding1842723misfielding
misfire12229893misfir__e
misfired14238543misfir_ed
misfires132210583misfir_es
misframing1846233misframing
misgivings1742413misgivings
misguiding1544343misguiding
mishearing1647883mishearing
mishitting1645993mishitting
misjoining2085293misjoining
miskicking1844243miskicking
mislaying1557913mislaying
mislying1437843mis_lying
mismaking18118023mismaking
mismarking1955863mismarking
mismating141211823mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
misparsing1546613misparsing
misparting1538083misparting
mispoising1546583mispoising
mispricing1746713mispricing
misprint12912973mis_print
misprizing2447533misprizing
misraising1348123misraising
misrating121014853misrating
misruling1237493misruling
missaying1537633missaying
missing103619073mis__sing
missioning1347403missioning
missorting1347123missorting
missuiting1356743missuiting
mistaking1699693mistaking
misterming1538603misterming
misting103623383mis__ting
mistitling1346223mistitling
mistuning1237673mistuning
mistyping1744723mistyping
misusing1138893mis_using
miswording1744863miswording
miswriting1646843miswriting
misyoking1944923misyoking
mitering113015403mi_tering
mitring103514143mi__tring
mustering122212333mustering
niffering1645133niffering
outfiring1338163outfiring
pilfering1536393pilfering
prefiring1559073prefiring
refiring123513923_refiring
respiring12159903respiring
siring75128313__s_iring
sistering101213753sistering
spiring103918183__spiring
suspiring1245703suspiring
tiffining1642913tiffining
visiting1238393vis_iting
visoring1238373vis_oring

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.420425454.8
2DLD Change Limit1486411046.12624264.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.59227107.3
 
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.