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

80 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
discreet1141318(None) 
discrete11410281discrete
discept12310622disc_ept
discredit1345362discredit
discreeter1344732discreeter
discreetly1653512discreetly
indiscreet1353502indiscreet
bescreen1244313bescreen
bystreet1345023bystreet
decree93117783d_ecree_
decreed112710263d_ecreed
decreer10269123d_ecreer
decrees102513123d_ecrees
descent102616293desc_ent
descried1248083descried
descrier1157623descrier
descries11311923descries
diciest103316523di_ciest
direct93817333di__rect
direst75024243di__rest
disagree1048353disagree_
disagreed1245463disagreed
disagrees1146403disagrees
disarmed1238643disarmed
disarmer1138033disarmer
discant103017263disc_ant
discarded1437083discarded
discarder1346753discarder
discase102912863discase_
discased122510853discased
discases112014503discases
disced104914653disc__ed
discepts1336743disc_epts
discern1038493disc_ern
discerned1347863discerned
discerner1246943discerner
discerns1138163discerns
discoed11312483disc_oed
discorded1438133discorded
discount11811313discount
discover1439563discover
discovert1548793discovert
discredits1453773discredits
discreetest1453913discreetest
discrepant1554243discrepant
discretely1653693discretely
discrown1445283discrown
discuses113112863discuses
disherit12412523disherit
dishiest12313683dishiest
disject17268673dis_ject
disorder1038133disorder
disorient10412523disorient
dispread1247103dispread
disquiet1879933disquiet
disrate81418523dis_rate
disroot8413563dis_root
disrupt1048633dis_rupt
disseat83816923dis_seat
dissect103614133dis_sect
dissent84018683dis_sent
dissert83720693dis_sert
distent84120853dis_tent
distract11313023distract
distrait9414343distrait
distress9311713distress
district11413873district
distrust949953distrust
dosseret91111513dosseret
miscreant1347573miscreant
miscreate1348893miscreate
mismeet113215163mis_meet
mistreat10313113mistreat
onscreen1044253onscreen
rescreen1046703rescreen
scree720031713__scree_
screed95718933__screed
screen85216023__screen
screes85023973__screes
street64125773__street

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 Limit146162806.43622710.1
3Display Results80800.0332424.2
 (SQL Overall)178691806.89225927.3
 
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.