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 “modulars” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
modulars116583(None) 
modular1087361modular_
medlars10259442med_lars
modelers1138462modelers
modularly1542732modularly
modulate1138592modulate
modulates1238052modulates
modulators1345332modulators
modules102511002modul_es
modulus10245332modul_us
molars85517322mo__lars
morular978222morular_
morulas959712morula_s
nodular876702nodular_
oculars948362_oculars
cedulas1058503cedula_s
coddlers12359173coddlers
collars93816573co_llars
copular113810603copular_
copulas113811563copula_s
corulers1039773corulers
cougars1038443co_ugars
dollars83311023do_llars
doulas75114993do_ula_s
foulard11257283fo_ulard
foulards12266463fo_ulards
globulars1242453globulars
insulars8137323insulars
jocular1637303jocular_
jugulars1643233jugulars
lobular936663lobular_
locular938953locular_
macular113011943macular_
maculas113114023macula_s
malars85020683m__alars
maulers94213303m_aulers
meddlers12318203meddlers
medlar93010463med_lar_
medullar1143463medullar_
medullary1542243medullary
medullas1144513medullas
medusans1144143medusans
medusas1036213medusa_s
middlers123410193middlers
midyears1443403midyears
modals93914453mod__als
modeler1039293modeler_
modellers1245393modellers
models94216353model__s
modularity1663323modularity
modulated1336713modulated
modulator1245793modulator
modulatory1644423modulatory
module93011033modul__e
moduli9267963modul__i
modulo9256983modul__o
modus85417203modu___s
moguls948553mogul__s
mohurs1135933mohu__rs
moilers93615203mo_ilers
molar75223093mo__lar_
molas75132093mo__la_s
mollahs12328283mo_llahs
monoculars1444503monoculars
moolahs12347383mo_olahs
moolas83615593mo_ola_s
mortars93411523mo_rtars
morula8710473morula__
morulae958963morula_e
mottlers10388183mottlers
moulage1037903mo_ulage
moulages1138053mo_ulages
moulders11348343mo_ulders
moulds94910993mo_ul_ds
moulins9312703mo_ulins
moulters103510783mo_ulters
moults84713703mo_ul_ts
mousers95216443mo_users
muddlers12428813muddlers
mudflaps1641803mudflaps
mudflats1442983mudflats
mudlark1463913mud_lark
mudlarks1542883mud_larks
mutular936643mutular_
mylars114310443m__ylars
nodules8269703nodul_es
nodulous944733nodulous
ocular8610133_ocular_
ovular946833_ovular_
ovulary1344913_ovulary
pedlars103210213ped_lars
polars84419353po__lars
poplars113910333po_plars
popular11319563popular_
poulard10299733po_ulard
poulards11288233po_ulards
radular837833radular_
radulas839583radula_s
regulars936253regulars
seculars10219393seculars
simulars1047073simulars
soucars938423so_ucars
titulars845863titulars
toddlers10346963toddlers
tolars64817943to__lars
torulas759853torula_s
undular837123undular_
uvulars1044413_uvulars
yodelers1235673yodelers
yodlers11298923yod_lers
zonular1656493zonular_
zonulas1637023zonula_s

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 Filter1786911461620.1601116818.8
2DLD Change Limit1461621127.60619216.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.81222873.9
 
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.