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

82 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
douceurs114279(None) 
douceur1043111douceur_
dousers84817272douse_rs
adducers1283443adduce_rs
auteurs7137503_auteurs
bouncers12309353bounce_rs
concours1239473concours
concurs11311473conc_urs
couchers153513863couchers
couters93827303coute_rs
dancers103413093dance_rs
danseurs933433danseurs
daubers104610423daube_rs
deicers103612733deice_rs
deuces94015513deuce__s
dicers94720743d_ice_rs
diseurs839403d_iseurs
dobbers123513253dobbe_rs
docents102810803do_cents
dockers143715003do_ckers
doctors1039993do_ctors
dodders105511793dodde_rs
dodgers105213823dodge_rs
doers65225713do__e_rs
doffers14359853doffe_rs
dogears937513do_gears
doggers104413433dogge_rs
dolours8438823do_lours
doozers17419293dooze_rs
dopers95522483do_pe_rs
dormers104313923dorme_rs
dorpers104113173dorpe_rs
dorsers83516303dorse_rs
dosers75723633do_se_rs
dossers84516233dosse_rs
doters74423913do_te_rs
dotters83715973dotte_rs
doublers11288503doublers
doublure1142593doublure
doublures1242573doublures
doubters11257393doubters
douce85518423douce___
doucely1344883douce_ly
douches134315233douc_hes
dourer74215273doure_r_
douser75621633douse_r_
douses74928933douse__s
douzepers2142043douzepers
dowers104523293do_we_rs
downers113912773downe_rs
dowsers115013533dowse_rs
dozers164815423do_ze_rs
duces86327473d_uce__s
duckers143214713d_uckers
dupers94615603d_upe_rs
farceurs13464723farceurs
forcers124215713force_rs
gougers94911763gouge_rs
hauteurs1133733hauteurs
housers104717813house_rs
louvers10359103louve_rs
mousers95216443mouse_rs
occurs10136553_o_ccurs
outers64230173_oute_rs
poseurs9378293po_seurs
pouncers12349203pounce_rs
pourers93513673poure_rs
pouters94221873poute_rs
rousers75220143rouse_rs
routers74822873route_rs
saucers93712133sauce_rs
soccers1138393socce_rs
soucars938423souc_ars
souters74422603soute_rs
touchers133611213touchers
touchups1543083touchups
tourers73512743toure_rs
touters74018353toute_rs
trouveurs1241643trouveurs
voicers12348993voice_rs
vouchers16418623vouchers
voyeurs1332423vo_yeurs

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.420425454.8
2DLD Change Limit146162826.79621507.1
3Display Results82820.0332484.8
 (SQL Overall)178691827.24924650.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.