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

210 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
masquer1826646(None) 
masque17249381masque_
masquers19195701masquers
masques18239361masques
basque17259082basque_
basques18248672basques
casque17299272casque_
casqued19235632casqued
casques18278982casques
lacquer18135152lacquer
manque17259512manque_
marque172410502marque_
marquee18218582marquee
marques182610862marques
maser75029972mas__er
masher114123202mas_her
masker124416102mas_ker
masseur935702masseur
massier93615222massier
master84831342mas_ter
mosque17287162mosque_
mosques18256912mosques
amasser9418733amas_ser
arguer74510543_arguer
ashier94714833_ashier
ashler9459973_ashler
asker96418783_as_ker
asper75520433_as_per
assumer965363_assumer
assure6610773_assure
assurer767793_assurer
aster55434893_as_ter
banquet1839783banquet
barque17239553barque_
barques18259643barques
baser74828923bas__er
basher115123813bas_her
baster85333593bas_ter
bisque17257843bisque_
bisques18236893bisques
bosque17257733bosque_
bosques18217973bosques
bosquet18249223bosquet
brusquer1942643brusquer
caique17318803caique_
caiques18248793caiques
calque17289843calque_
calqued19306523calqued
calques182710193calques
cashier123713323cashier
caster85232573cas_ter
chequer2135153chequer
claquer18287353claquer
conquer1838623conquer
dasher104318983das_her
dashier114311183dashier
dasyure1153823dasyure
easier64218463eas_ier
easter65027983eas_ter
faquir1834313fa_quir
faster94625773fas_ter
gasher104320373gas_her
gasper94515543gas_per
gasser75017773gas_ser
gassier83812573gassier
gaster75027353gas_ter
hastier103916623hastier
issuer646623_issuer
jasper154610383jas_per
kasher134915033kas_her
lacquers19125033lacquers
lacquey21143803lacquey
laser54633323las__er
lasher94824533las_her
lassoer7379383lassoer
laster64830633las_ter
macaber1336163macaber
macaque2044053macaque_
macaques2143953macaques
macer912126943ma__cer
madder103515593ma_dder
maguey1236833ma_guey
mailer84724183ma_iler
maimer104514593ma_imer
maker114127813ma__ker
malmier113611953malmier
maltier93015483maltier
mammer94218863ma_mmer
mamzer19459833ma_mzer
manager103413583manager
maneuver1343333maneuver
manger94325003ma_nger
mangier104114063mangier
mangler103215643mangler
manlier92414023manlier
manner84020513ma_nner
manure8313653ma_nure
manurer938583manurer
mapper124516093ma_pper
maqui16249953ma_qu_i
maquis17249483ma_quis
marauder1144553marauder
marbler113511673marbler
marcher143912973marcher
mariner93315993mariner
marker124420393ma_rker
marlier92614773marlier
marquees19206243marquees
marquess19204953marquess
marquetry2362613marquetry
marquis18247063marquis
marrer83716673ma_rrer
marrier93817523marrier
marshier1337593marshier
masers84623453mas__ers
mashed125325043mas_hed
mashers124621053mas_hers
mashes115030003mas_hes
mashie11315933mashie_
mashies12318253mashies
masked134316523mas_ked
maskeg13388693mas_keg
maskers133913843mas_kers
masoned1039803masoned
masquerade2251743masquerade
massager1136873massager
masse75125293mas_se_
massed94421323mas_sed
masses85028713mas_ses
masseter1037063masseter
masseurs1034923masseurs
masted94025803mas_ted
masters94628923mas_ters
mastery124214323mas_tery
matcher143214283matcher
mater74438863ma__ter
matier84321523ma_tier
matter84325343ma_tter
mature8313463ma_ture
maturer938973maturer
mauger93813483ma_uger
mauler84416713ma_uler
maunder10328683maunder
mazer165722423ma__zer
mazier175013063ma_zier
measlier1036013measlier
measure939033meas_ure
measurer1035953measurer
meshier123410853meshier
mesquit18387953mesquit
messier93412923messier
misaver1249813misaver
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdoer1048633misdoer
miser75430403mis__er
misquoter2043383misquoter
mister84728563mis_ter
mistier93418713mistier
misuser93210443misuser
mosher114719793mos_her
mosser84618273mos_ser
mossier94413813mossier
muser76024123mus__er
musher113820573mus_her
mushier123813593mushier
muskier134312733muskier
mussier93314363mussier
muster84724523mus_ter
mustier94017963mustier
nastier74115293nastier
opaquer1842403opaquer
parquet18311583parquet
pasquil1843923pasquil
passer84721033pas_ser
paster85734373pas_ter
pastier94320383pastier
pasture9311463pasture
pasturer1037523pasturer
racquet1838743racquet
raser55633413ras__er
rasher95024123ras_her
rasper83917333ras_per
raspier93110643raspier
raster64731443ras_ter
rasure6311423ras_ure
rescuer939033rescuer
risque15227453risque_
sacque17107113sacque_
sacques18106863sacques
sassier73413233sassier
smasher123911023smas_her
squeg1588033__squeg
suer45334033__s_uer
taster64930573tas_ter
tastier711817093tastier
torquer16205323torquer
uniquer1675783uniquer
usque14137733_usque_
usques15126803_usques
vaguer10448443va_guer
valuer93911443va_luer
vaquero1942643va_quero
vaster94521023vas_ter
vastier103613203vastier
washer124720393was_her
washier133611153washier
waspier12259053waspier
waster95228943was_ter

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.393454684.5
2DLD Change Limit1340272106.98319193.3
3Display Results2102100.0633333.3
 (SQL Overall)1786912107.43924020.8
 
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.