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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
mauve10401327(None) 
fauve114712071fauve
mauves113811551mauves
amuse75920832amuse
ave67748702_a_ve
calve105919922calve
carve106227752carve
cause75225352cause
cave95941262ca_ve
daube85015302daube
eave75733582ea_ve
fauves125610422fauves
fave105532962fa_ve
gauge76117902gauge
gauze155712972gauze
gave84634052ga_ve
halve114818922halve
haute89521612haute
have106137072ha_ve
lave75642142la_ve
mabe85733362ma_be
mace87345792ma_ce
mache125925302mache
macle96127002macle
macule104115272macule
made75440242ma_de
madre85720172madre
mae57659112ma__e
mage75739132ma_ge
mahoe10315572mahoe
maile75232222maile
maize164618562maize
make105537892ma_ke
male66052302ma_le
mamie95826002mamie
mane65052032ma_ne
mange84930192mange
manse75528232manse
manure8313652manure
maple95521142maple
mare64759332ma_re
marge85328332marge
marse76231152marse
marvel113712002marvel
marvy135014032marvy
masse75125292masse
mate65154222ma_te
matte75626842matte
mature8313462mature
maud75325402mau_d
mauds85519272mauds
mauger93813482mauger
maugre9308972maugre
maul64830722mau_l
mauled94817822mauled
mauler84416712mauler
mauls76524952mauls
maumet103518882maumet
maun65727212mau_n
maund85515452maund
maut65448452mau_t
mauts75927192mauts
maven104816892ma_ven
mavie104722562mavie
maybe12311132maybe
maze155434982ma_ze
moue65835572mou_e
mouse77133002mouse
move96630722m_ove
mule65236972m_ule
mure65941332m_ure
muse67136032m_use
mute65136872m_ute
naive85116212naive
nave75732312na_ve
parve109824852parve
pause75021832pause
pave96133892pa_ve
rave75542092ra_ve
salve85022132salve
sauce75121652sauce
saute55028082saute
save75741362sa_ve
suave83519872suave
taupe7314162taupe
valve114515932valve
varve115716852varve
waive114214602waive
wave105234732wa_ve

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800891.59333772.8
3Display Results89890.0165562.5
 (SQL Overall)178691891.91993116.7
 
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.