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

99 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
moghul124447(None) 
moghuls1343611moghuls
mogul8310211mog_ul
moguls948552mog_uls
mohel104914832mo_hel
mohur1036512mo_hur
mugful1235402mugful
mughal1236272mughal
bagful1237213bagful
bogus85616473bog_us
boxful18145273boxful
boxhaul1943013boxhaul
consul82312303consul
foul77027583fo__ul
ghoul959053__ghoul
gul45832793__g_ul
hognut1039413hognut
joyful1943843joyful
jugful1734603jugful
kohl113911713ko_h_l
magnum1136733magnum
magus85318753mag_us
manful11610213manful
maul64830723m__aul
methyl1436403methyl
miaul71612123m_iaul
might113827083migh_t
mights123516253mights
mighty154310213mighty
moanful12105003moanful
mocha1249923moch_a
mochas13310663mochas
mochila1446523mochila
mockup1634073mockup
modal85919243mo_dal
model84521693mo_del
module93011033mo_dule
moduli9267963mo_duli
modulo9256983mo_dulo
modus85417203mo_dus
mog66949673mog___
mogged115215393mogged
moggie103210103moggie
moggy125212163mog_gy
mogs75439333mog__s
moguled1135933mog_uled
mohels115011323mo_hels
mohurs1135933mo_hurs
moil65534093mo__il
mol56654593mo___l
molal75120343mo_lal
moll66735703mo__ll
momus96116113mo_mus
mongol94912533mongol
mongrel1036333mongrel
monohull1343953monohull
mool67533863mo__ol
moral75533433mo_ral
morel75729093mo_rel
morgue938113morgue
morsel85815893morsel
mortal84616853mortal
morula8710473mo_rula
mosh95227603mosh__
moshav1446053moshav
moshed124517493moshed
mosher114719793mosher
moshes115222873moshes
mosque17287163mosque
motel76623243mo_tel
moth96731333moth__
mother113718643mother
moths106021553moth_s
mothy136214553moth_y
moue65835573mo__ue
mould86015753mo__uld
moult74728723mo__ult
mouthful1643573mouthful
mugfuls1344003mugfuls
muggur10325593muggur
mughals1355763mughals
ogham1138253_ogham
potful1138083potful
rogue66417533rog_ue
schul102510413_schul
shul75823153__shul
sobful1136333sobful
songful1145173songful
sorghum1343513sorghum
soul46435713so__ul
togue64816303tog_ue
topful1136543topful
tophus115210363tophus
vogue95613043vog_ue
woeful1236363woeful
woful1158173wo_ful
yogh116616143yogh__
yoghs125410593yogh_s
yoghurt1443773yoghurt

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716995.12322002.0
3Display Results99990.0333000.0
 (SQL Overall)178691995.53232301.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.