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

70 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
mollusc1110309(None) 
mollusca1282151mollusca
molluscs12102591molluscs
mollusk13103121mollusk
molls75129782moll_s_
molluscan13112072molluscan
molluscum1551352molluscum
mollusks14102652mollusks
bolls75531313boll_s_
bolus79125543bo_lus_
callus85317073callus_
coleus86818273coleus_
collude10337993collude
dollish11610093dollish
dolls66126923doll_s_
folles93820473folles_
follis93113903follis_
gallus74313203gallus_
hollas94616903hollas_
hollos95320633hollos_
lolls512121733loll_s_
malleus92911313malleus_
malls76233433mall_s_
mells75031333mell_s_
milles84526563milles_
mills75435053mill_s_
modulus10245333modulus_
modus85417203mo_dus_
moguls948553moguls_
moils76125753moil_s_
molars85517323molars_
molas75132093mo_las_
molds85324833mo_lds_
moles74747923mo_les_
molest85022743mo_lest
molies84429513molies_
moll66735703moll___
mollah11319453moll_ah
mollahs12328283mollahs
mollie83517103moll_ie
mollies93420233mollies
mollify1555503mollify
molluscans14111853molluscans
molluskan15111623molluskan
molly105222493moll__y
mols65948573mo_l_s_
molts76032093mo_lts_
momus96116113mo_mus_
moolas83615593moolas_
mools76027173mool_s_
moulds94910993moulds_
moults84713703moults_
mouse77133003mo__use
mousy106716943mo__usy
mucluc1245053muclu_c
muclucs1343683muclucs
mullas84215933mullas_
mulls75124153mull_s_
ollas54218283_ollas_
poilus82210573poilus_
pollist9816603pollist
polls74627723poll_s_
pollute937383pollute
rolls55326233roll_s_
soleus64615613soleus_
solus54726983so_lus_
tolls54728433toll_s_
toluic837693to_luic
tolus55024483to_lus_
villus93611223villus_

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.406440125.6
2DLD Change Limit134027706.12621878.4
3Display Results70700.0164375.0
 (SQL Overall)178691706.54827289.4
 
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.