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

141 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
marquis1824706(None) 
maquis17249481ma_quis
marques182610861marques
marquise19206171marquise
barques18259642barques
charquis2243932charquis
maqui16249952ma_qui_
marauds1037552marauds
markups1534962markups
marque172410502marqu_e
marquee18218582marquee
marquees19206242marquees
marquess19204952marquess
marquises20225702marquises
masques18239362masques
yanquis1943722yanquis
acquit17610323_acquit
acquits1857293_acquits
aquas142412613_a_quas
arcus76918863_arcu_s
argues74516413_argues
argus66716543_argu_s
arris56824683_ar_ris
arsis55722423_ar_sis
arums75517833_ar_ums
barbuts11439843barbuts
bariums1139143bariums
baroques1934863baroques
barque17239553barqu_e
basques18248673basques
caiques18248793caiques
calques182710193calques
carfuls1249133carfuls
carpus105514303carpu_s
casques18278983casques
charqui2144003charqui_
charquid2342923charquid
cirques1836463cirques
croquis1834763croquis
earbuds1044633earbuds
earfuls1036863earfuls
faquir1834313fa_quir
faquirs1943863fa_quirs
jarfuls1754773jarfuls
laris54737463lar__is
larrups934733larrups
larums83610533lar_ums
macaques2143953macaques
magnums1234683magnums
magus85318753ma_gu_s
mahouts1237143mahouts
makeups1533603makeups
mamluks1543313mamluks
manque17259513manqu_e
mantis83926033ma_ntis
mantuas93410993mantuas
manus75924933ma_nu_s
maquila1844703ma_quila
maquilas1944033ma_quilas
maracas11313773maracas
maras75443293mar__as
maraud938943marau_d
marbles114516653marbles
marcels113212373marcels
marches143921173marches
marcs95726623mar__cs
mares76457633mar__es
margays1337493margays
marges94525713mar_ges
margin94016853mar_gin
margins103815193margins
maria75032883mar__ia
marinas93519393marinas
marines93928013marines
marish114319053mar__ish
markas124717003mar_kas
markers133516103markers
markets133314033markets
markkas12356083markkas
marks115933483mar__ks
markup1436903marku_p
marlin84220903mar_lin
marlins93420473marlins
marls75535163mar__ls
marmots11311513marmots
maroons92615553maroons
marquisate2152393marquisate
marrams11310123marrams
marrers93414313marrers
marries93825283marries
marrons93216973marrons
marrows122911823marrows
mars66261873mar___s
marses84827113mar_ses
marshes123615373marshes
marsupia1242473marsupia
martens93714953martens
martin84122523mar_tin
martinis103311613martinis
martins93322063martins
marts77442233mar__ts
martyrs1234893martyrs
marvels123810093marvels
masque17249383masqu_e
masquer18266463masquer
masquers19195703masquers
mauds85519273ma__uds
mauls76524953ma__uls
mauts75927193ma__uts
mavis105622723ma__vis
maxis145721563ma__xis
merisis93213173merisis
mesquit18387953mesquit
mesquits19496483mesquits
mezquit27365113mezquit
mezquits28364423mezquits
morgues1038273morgues
morris83814733mor_ris
mosques18256913mosques
murmurs1134523murmurs
naris55735293nar__is
paresis93315093paresis
pareus85420743pareu_s
paris75145943par__is
parous84024163parou_s
parquet18311583parquet
parquets1936413parquets
parvis116114803par_vis
pasquil1843923pasquil
pasquils1943123pasquils
remarques2093393remarques
sacques18106863sacques
sardius839553sardius
saris54544953sar__is
tarsus6310513tarsu_s
torques16217513torques
turquois1742453turquois
vanquish2343543vanquish
varus85921183var_u_s
warmups1433813warmups
yanqui1843383yanqui_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271416.81319672.2
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.26524596.1
 
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.