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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
marquee1821858(None) 
marque172410501marqu_e
marquees19206241marquees
marques182610861marques
barque17239552barqu_e
barques18259642barques
manque17259512manqu_e
marquess19204952marquess
marquis18247062marquis
marquise19206172marquise
masque17249382masqu_e
masquer18266462masquer
masques18239362masques
parquet18311582parquet
aquae142212713_a_quae
arbute8311043_arbute
argue64818443_argu_e
argued84311173_argued
arguer74510543_arguer
argues74516413_argues
armure8710133_armure
arouse65019983_arouse
banquet1839783banquet
barbule1137943barbule
bargee94624443bar_gee
baroque1835103baroqu_e
baroques1934863baroques
barquette2064903barquette
basque17259083basqu_e
basques18248673basques
caique17318803caiqu_e
caiques18248793caiques
calque17289843calqu_e
calqued19306523calqued
calques182710193calques
carouse9614423carouse
casque17299273casqu_e
casqued19235633casqued
casques18278983casques
cirque1735853cirqu_e
cirques1836463cirques
lacquer18135153lacquer
lacquey21143803lacquey
laree56036293lar__ee
macaque2044053macaqu_e
macaques2143953macaques
machree1438513machree
macule104115273ma_cule
maguey1236833ma_guey
mallee84525593ma_llee
mammee94417853ma_mmee
manatee9317663manatee
manure8313653ma_nure
maquette1946113ma_quette
maqui16249953ma_qu_i
maquis17249483ma_quis
maraud938943marau_d
marauded1244333marauded
marauder1144553marauder
marauds1037553marauds
marble104219103mar_ble
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marcel103714853mar_cel
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marchese15358913marchese
mare64759333mar___e
maremme1054603maremme
mares76457633mar__es
marge85328333mar__ge
marges94525713mar_ges
marine84230403mar_ine
mariner93315993mariner
marines93928013marines
marked133921623mar_ked
marker124420393mar_ker
market123226043mar_ket
markup1436903marku_p
markups1534963markups
marled95523163mar_led
marlier92614773marlier
marline93320953marline
marlite92917073marlite
marmite112413993marmite
marquesses2143353marquesses
marquetry2362613marquetry
marquises20225703marquises
marred95421043mar_red
marrer83716673mar_rer
married104715303married
marrier93817523marrier
marries93825283marries
marse76231153mar__se
marses84827113mar_ses
marshes123615373marshes
marted94425213mar_ted
marten84518263mar_ten
martlet93419153martlet
marvel113712003mar_vel
masquers19195703masquers
matinee92415613matinee
mature8313463ma_ture
mauve104013273ma__uve
mergee94018133mer_gee
morgue938113morgu_e
morgues1038273morgues
mosque17287163mosqu_e
mosques18256913mosques
paraquet1948783paraquet
pardee93922023par_dee
parolee94119633parolee
paroquet1947283paroquet
parqueted2144213parqueted
parquets1936413parquets
parure8312523par_ure
racquet1838743racquet
remarque1993553remarqu_e
remarques2093393remarques
sacque17107113sacqu_e
sacques18106863sacques
saree55044663sar__ee
tartufe1064673tartufe
torque15237673torqu_e
torqued17224893torqued
torquer16205323torquer
torques16217513torques

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.1401276364.3
2DLD Change Limit1340271306.26621389.6
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.45227695.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.