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 “discomfited” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
discomfited205344(None) 
discomfit1754682discomfit__
discomfits1853242discomfit_s
discomforted2162732discomforted
discomfiting2153143discomfiting
discomfiture2061923discomfiture
discomfitures2161823discomfitures
discommoded20112973discommoded
discomposed1953373discomposed
disconfirmed2172543disconfirmed
discounted1447843disco_unted
discredited1653603discredited
miscomputed2053183miscomputed
diatomite1246024diatom_ite_
diatomites1345364diatom_ites
discanted1339334disc__anted
discepted1547534disc__epted
disciplined1753544disciplined
disclaimed1644414disc_laimed
discoed11312484disco____ed
discoid11311244disco__i__d
discolored1445624disco_lored
discoloured1553304discoloured
discomfort1853934discomf_ort
discomforts1952624discomforts
discommend1853614discom_mend
discommended2152344discommended
discommode18123174discommode_
discommodes19123394discommodes
discompose1753914discompose_
discomposes1854124discomposes
disconcerted1854344disconcerted
disconfirm1853164disconfi_rm
disconfirms1952924disconfirms
disconnected1853714disconnected
discontented1655314discontented
discontinued1654034discontinued
discophile1855114discophile_
discophiles1954334discophiles
discorded1438134disco__rded
discounter1347024disco_unter
discouraged1653694discouraged
discoursed1445794disco_ursed
discovered1765884disco_vered
disherited1546704dis_herited
disinvited1544404dis_invited
disjoined1845834disjo__ined
disjointed1944834disjo_inted
dislocated1497524dislo_cated
dismasted1346834dis__masted
dismounted1445414dismo_unted
disobliged1552664dis_obliged
dispirited1445934dis_pirited
disported13310304dispo__rted
disrooted1147624disro__oted
dissociated1555604dissociated
distorted1139374disto__rted
disunited1177274dis__united
miscited13310424misc___ited
miscoined1448444misco__ined
miscompute1883714miscompute_
miscomputes1963504miscomputes
miscopied1647174misco_pi_ed
miscounted1546064misco_unted
viscometer1745304viscom_eter

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819658.42317668.2
3Display Results65650.0302166.7
 (SQL Overall)178691658.87320138.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.