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

264 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
masque1724938(None) 
basque17259081basque
casque17299271casque
manque17259511manque
marque172410501marque
masquer18266461masquer
masques18239361masques
mosque17287161mosque
barque17239552barque
basques18248672basques
bisque17257842bisque
bosque17257732bosque
caique17318802caique
calque17289842calque
casqued19235632casqued
casques18278982casques
macaque2044052macaque
maqui16249952ma_qui
marquee18218582marquee
marques182610862marques
mashie11315932mashie
masquers19195702masquers
masse75125292mas_se
miscue10412222miscue
mosques18256912mosques
risque15227452risque
sacque17107112sacque
usque14137732_usque
ague55725923_a_gue
aqua132813963_a_qua
aquae142212713_a_quae
argue64818443_argue
ascus75013583_ascus
aside65122083_aside
assume897563_assume
assure6610773_assure
astute6310763_astute
banquet1839783banquet
baroque1835103baroque
barques18259643barques
bascule1136573bascule
base64847023bas__e
baste74829983bas_te
battue84311003battue
bisques18236893bisques
bosques18217973bosques
bosquet18249223bosquet
brusque1843703brusque
cacique20205693cacique
caiques18248793caiques
calqued19306523calqued
calques182710193calques
cangue91012443cangue
case65848083cas__e
caste75932363cas_te
castle84918963castle
casus76419253cas_us
cazique27194033cazique
cheque2036663cheque
cinque1736853cinque
cirque1735853cirque
claque17338563claque
clique17289193clique
cloque17288743cloque
dassie74615573dassie
dasyure1153823dasyure
ease45042333eas__e
ensue54013833ens_ue
fescue1137493fescue
fique1739143_fique
gangue81310573gangue
hassle93711593hassle
haste85927863has_te
issue559213_issue
lacquer18135153lacquer
lacquey21143803lacquey
lalique1644423lalique
langue71012173langue
lase46148513las__e
lassie64917743lassie
mabe85733343ma__be
macaques2143953macaques
mace87345783ma__ce
mache125925303ma_che
mackle143716433mackle
macle96127003ma_cle
macule104115273macule
madame1139853madame
made75440233ma__de
madre85720173ma_dre
mae57659103ma___e
mage75739123ma__ge
magnum1136733magnum
magpie1139093magpie
maguey1236833ma_guey
magus85318753ma_gus
mahoe10315573ma_hoe
mahout11415803mahout
maigre9309163maigre
maile75232213ma_ile
maize164618553ma_ize
make105537883ma__ke
makeup1434863makeup
malate84624553malate
male66052293ma__le
malgre9299303malgre
malice104818483malice
maline84529083maline
mallee84525593mallee
mamie95826003ma_mie
mamluk1434743mamluk
mammae94613213mammae
mammee94417853mammee
mammie94313783mammie
manage93818903manage
manche133515103manche
mane65052013ma__ne
manege94113203manege
manful11610213manful
mange84930183ma_nge
mangle93921323mangle
manse75528223ma_nse
mantle84420923mantle
mantua84412023mantua
manure8313653manure
manus75924923ma_nus
maple95521143ma_ple
maquis17249483ma_quis
maraud938943maraud
marble104219103marble
mare64759323ma__re
marge85328333ma_rge
marine84230403marine
markup1436903markup
marquees19206243marquees
marquess19204953marquess
marquis18247063marquis
marquise19206173marquise
marse76231153ma_rse
mas58175813mas___
masa65034713mas__a
masala8311813masala
masas75630413mas_as
mascon103612743mascon
mascot104016073mascot
maser75029973mas_er
masers84623453masers
mash96039393mas__h
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashies12318253mashies
mashy136016503mas_hy
masjid16187313masjid
mask105227353mas__k
masked134316523masked
maskeg13388693maskeg
masker124416103masker
masks115320533mas_ks
mason74820183mas_on
masoned1039803masoned
masons83916513masons
mass66044933mas__s
massa75518923mas_sa
massage1039893massage
massas85116463massas
massed94421323massed
masses85028713masses
masseur935703masseur
masseuse1044253masseuse
massier93615223massier
massif11412533massif
massive12289773massive
massy104518963mas_sy
mast65959953mas__t
masted94025803masted
master84831343master
mastic103119173mastic
mastix152310503mastix
masts77035763mas_ts
mate65154213ma__te
matte75626843ma_tte
mature8313463mature
maud75325393ma__ud
maugre9308973maugre
maul64830713ma__ul
maun65727203ma__un
maut65448443ma__ut
mauve104013273ma_uve
mavie104722563ma_vie
maxixe1435223maxixe
maybe12311123ma_ybe
maze155434973ma__ze
measle83513223meas_le
measure939033measure
mesne75116293mes_ne
mesquit18387953mesquit
mesquite19537043mesquite
mestee84523883mestee
misate81222693misate
miscued1239293miscued
miscues11312393miscues
miscut10614813miscut
mise66043573mis__e
mislie83219153mislie
misquote1945133misquote
misrule939353misrule
missus85312293missus
mistune9310653mistune
misuse83213643misuse
moresque1943013moresque
morgue938113morgue
moste75925083mos_te
moue65835573m__oue
muscae10410673muscae
muscle10310973muscle
muse67136033mus__e
museum1037703museum
muskie123412533muskie
mustee83922103mustee
mystique2242393mystique
omasum1035503omas_um
opaque1734213opaque
parquet18311583parquet
pase65346863pas__e
pasquil1843923pasquil
passe75525693pas_se
passee84522023passee
passus83610293passus
paste74932953pas_te
pastie85525523pastie
pasture9311463pasture
pique16410173_pique
plaque17317643plaque
pulque1736213pulque
racquet1838743racquet
rase46149983ras__e
rassle63813203rassle
rasure6311423rasure
remarque1993553remarque
rescue8313003rescue
roque144812133_roque
sacques18106863sacques
slue45332193__slue
smashup1443453smashup
spue66025523__spue
squeg1588033__squeg
sue35651463__s_ue
tasse54821843tas_se
tassie66017023tassie
taste55127233tas_te
tissue637333tissue
toque145113093_toque
torque15237673torque
tuque14469193_tuque
ubique1784883ubique
unique1558163unique
usques15126803_usques
vague96513113va_gue
value85719093va_lue
vase75629653vas__e
washup1435323washup
waste86125053was_te
yanqui1843383yanqui

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162646.01318745.4
3Display Results2642640.0803300.0
 (SQL Overall)1786912646.23328668.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.