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

44 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
multicourse155284(None) 
multicurie1454742multic_urie
multisource1552242multisource
minicourse14112283m_inicourse
multicolors1593603multicolors_
multicounty1852553multicounty
multiuse1046513multi__u_se
muticous1246933mu_ticou_s_
manticore1346084mantico_r_e
manticores1445754mantico_res
midcourse1442224m__idcourse
millicurie1452994millic_urie
minicourses15112204m_inicourses
multicar1247524multic_ar__
multicausal1552584multicausal
multicoated1654574multicoated
multicolor1474184multico_lor
multicolored1762544multicolored
multicolumn1762294multicolumn
multicopy1853984multico__py
multifoils1553994multifoils_
multiform1645834multifo_r_m
multilobe1345194multilo__be
multilobes1444904multilobes_
multimode1445754multimo__de
multiparae1445664multi_parae
multiphase1744654multi_phase
multipicture1872244multipictur_e
multipole1347064multipo__le
multipoles1446564multipoles_
multiport1347214multipo_r_t
multipurpose1861754multi_purpose
multisense1244634multi_sense
multitone1187764multito__ne
multitones1277364multitones_
multitude1246144multi_tu_de
multitudes1345864multi_tudes
multiuser1144984multi__u_ser
multivolume1852364multivolume
multure939184mult___ur_e
multures1039334mult___ures
mutinous1047654mu_tinou_s_
outcurse1045834ou_t_c_urse
telecourse1252324tel_ecourse

Search took 10 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.423422437.4
2DLD Change Limit148819449.09316366.3
3Display Results44440.0331333.3
 (SQL Overall)178691449.54918713.1
 
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.