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

96 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
douceur104311(None) 
douceurs1142791douceurs
douce85518422douce__
doucely1344882doucely
dourer74215272doure_r
douser75621632douse_r
adducer1184163adduce_r
auteur6107943_auteur
bouncer113811333bounce_r
concur10411103conc_ur
coucher144515853coucher
couter84930223coute_r
dancer94817613dance_r
danseur833663danseur
dauber94112013daube_r
deicer94114413deice_r
deuce84517493deuce__
deuced104112123deuce_d
deuces94015513deuce_s
dicer85426423d_ice_r
diseur738843d_iseur
dobber114015423dobbe_r
docent92918683do_cent
docker134417653do_cker
doctor938993do_ctor
dodder94712913dodde_r
dodger95817043dodge_r
doer57734703do__e_r
doffer133911353doffe_r
dogear838193do_gear
dogger95216783dogge_r
dolce85816683dolce__
dolour75710133do_lour
doozer163910463dooze_r
doper86128393do_pe_r
dopier93515923dopie_r
dormer94415903dorme_r
dorper94314573dorpe_r
dorser74819183dorse_r
doser66228563do_se_r
dosser74417973dosse_r
doter65428623do_te_r
dotier73917033dotie_r
dotter74419343dotte_r
doubler103110083doubler
doublure1142593doublure
doubter10298353doubter
douche124613223douc_he
douched144012113douched
douches134315233douches
dour56330433do___ur
dourest8312943dourest
douse66329723douse__
doused84821163douse_d
dousers84817273dousers
douses74928933douse_s
douzeper2042233douzeper
dower95027703do_we_r
downer104414923downe_r
dowser104716083dowse_r
dozer158419273do_ze_r
dozier163611633dozie_r
duce76933503d_uce__
duces86327473d_uce_s
ducker134317993d_ucker
duper85519003d_upe_r
farceur12525273farceur
forcer114917343force_r
fouler93614903foule_r
gouger86014363gouge_r
hauteur1033893hauteur
houser95322283house_r
louder74414603loude_r
louver94110393louve_r
mouser85822443mouse_r
occur9137323_o_ccur
outer55633303_oute_r
poseur8419403po_seur
pouncer113511233pounce_r
pourer84516043poure_r
pouter83923983poute_r
rouser65224083rouse_r
router65025843route_r
saucer84314103sauce_r
soccer1038543socce_r
soucar839323souc_ar
sourer63620213soure_r
souter64225923soute_r
toucher124814353toucher
touchup1443833touchup
tourer64115073toure_r
touter63821033toute_r
trouveur1141673trouveur
voicer113910543voice_r
voucher154110263voucher
voyeur1232863vo_yeur

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 Limit134027965.93622578.7
3Display Results96960.0332909.1
 (SQL Overall)178691966.37528030.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.