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

57 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
nocturn94465(None) 
nocturne1043391nocturne
nocturns1043711nocturns
noctuid1064382noctuid
noctule936082noctule
nocturnal1143212nocturnal
nocturnes1143842nocturnes
notturni841832notturni
notturno841552notturno
bourn75518483bo__urn
churn105113103__churn
cothurn1245033cothurn
couture9310613couture
curn66731883__c_urn
doctor938993doctor_
doctors1039983doctors
downturn1243223downturn
facture12108923facture
goldurn943323goldurn
inturn63411563_inturn
lectern937033lectern
lecture9149513lecture
mourn77215013mo__urn
nature6311263n_ature
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
noctuids1152853noctuids
noctules1036583noctules
noctuoid1163493noctuoid
nonjury1744013nonjury
northern1145583northern
nostrum946943nostrum
notary92310713no_tary
noter55025643no_ter_
noters64020993no_ters
notion64516583no_tion
notum7611683no_tu_m
noun45724183no__u_n
nurture736643nurture
occur9137323_occur_
occurs10136553_occurs
octan71313483_oct_an
outburn936903_outburn
outrun63213293_outrun
outturn737123outturn
picture1158613picture
postburn1243923postburn
postern93615603postern
posture9313253posture
return623222523_return
sojourn1442893sojourn
taciturn1042653taciturn
torture738593torture
turn46330383___turn
upturn8286243_upturn
yourn87512773yo__urn

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027577.47017942.0
3Display Results57570.0134384.6
 (SQL Overall)178691577.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.