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

69 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
fauve11471207(None) 
fauves125610421fauves
fave105532961fa_ve
mauve104013271mauve
ave67748702_a_ve
calve105919922calve
carve106227752carve
cause75225352cause
cave95941262ca_ve
daube85015302daube
eave75733582ea_ve
fable105824752fable
face96140122fa_ce
fade85736342fa_de
fadge104817002fadge
fake115534942fa_ke
false84818122false
fame95639392fa_me
fane75343572fa_ne
farce104925322farce
fare76354462fa_re
farle86929242farle
fate75444282fa_te
fauces114916152fauces
faucet115816552faucet
faugh125712962faugh
fauld95214492fauld
fault85428312fault
faun76226622fau_n
fauna84816512fauna
faunae95210372faunae
fauns84516752fauns
faux146519072fau_x
fava106820262fa_va
faves115331422fa_ves
favus114311732favus
faze165630042fa_ze
five107629742f_ive
flue75329852flu_e
fluke125016892fluke
flume106021172flume
flute86823752flute
fume96727632f_ume
fuse76429992f_use
fuze166422372f_uze
gauge76117902gauge
gauze155712972gauze
gave84634052ga_ve
halve114818922halve
haute89521612haute
have106137072ha_ve
lave75642142la_ve
mauves113811552mauves
naive85116212naive
nave75732312na_ve
parve109824852parve
pause75021832pause
pave96133892pa_ve
rave75542092ra_ve
salve85022132salve
sauce75121652sauce
saute55028082saute
save75741362sa_ve
suave83519872suave
taupe7314172taupe
valve114515932valve
varve115716852varve
waive114214602waive
wave105234732wa_ve

Search took 4 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.610292936.1
2DLD Change Limit53800693.25016553.8
3Display Results69690.0302300.0
 (SQL Overall)178691693.89045936.0
 
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.