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

86 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
moghuls134361(None) 
moghul1244471moghul_
moguls948551mog_uls
mogul8310212mog_ul_
mohels115011322mo_hels
mohurs1135932mo_hurs
mugfuls1344002mugfuls
mughals1355752mughals
bagfuls1334753bagfuls
bogus85616473bog_u_s
boxfuls19113603boxfuls
boxhauls2042073boxhauls
consuls92412313consuls
fouls87221433fo__uls
ghouls1036043__ghouls
guls55930853__g_uls
hognuts1134183hognuts
jugfuls1843063jugfuls
kohls12437803ko_h_ls
magnums1234683magnums
magus85318753mag_u_s
mauls76524953m__auls
methyls1535453methyls
miauls8178713m_iauls
mights123516253migh_ts
mochas13310663moch_as
mochila1446523mochila
mochilas1544953mochilas
mockups1733343mockups
modals93914443mo_dals
models94216353mo_dels
module93011033mo_dule
modules102511003mo_dules
moduli9267953mo_duli
modulo9256973mo_dulo
modulus10245333mo_dulus
modus85417203mo_du_s
moggies113111723moggies
mogs75439333mog___s
moguled1135923mog_uled
mohel104914833mo_hel_
mohur1036513mo_hu_r
moils76125753mo__ils
molls75129783mo__lls
mols65948573mo___ls
momus96116113mo_mu_s
mongols103310823mongols
mongrels1135333mongrels
monohull1343953monohull
monohulls1443863monohulls
mools76027173mo__ols
morals85324633mo_rals
morels84820013mo_rels
morgues1038273morgues
morsels94112653morsels
mortals93914003mortals
morula8710473mo_rula
morulas959713mo_rulas
moshers124017843moshers
moshes115222873mosh_es
mosques18256913mosques
motels83616893mo_tels
mothers123717623mothers
moths106021553moth__s
moues75732843mo__ues
mould86015753mo__uld
moulds94910993mo__ulds
moult74728723mo__ult
moults84713703mo__ults
mouthfuls1742883mouthfuls
mugful1235403mugful_
muggurs11315103muggurs
mughal1236263mughal_
oghams1245853_oghams
potfuls1236293potfuls
rogues74617673rog_ues
schuls11299853_schuls
shuls85319713__shuls
sorghums1442633sorghums
souls55127363so__uls
togues76014243tog_ues
tophus115210363tophu_s
vogues104011923vog_ues
yoghs125410593yogh__s
yoghurt1443773yoghurt
yoghurts1551833yoghurts

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027866.73319906.0
3Display Results86860.0332606.1
 (SQL Overall)178691866.92225814.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.