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

154 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
musette93843(None) 
musettes1037431musettes
burette939852burette
casette9310392casette
curette939782curette
cuvette1235832cuvette
fumette1245522fumette
lunette737482lunette
mofette1296772mofette
mozette1886772mozette
mustee83922102mus_tee
rosette7310372rosette
ambulette1343733ambulette
anisette846773anisette
ariette7312373ariette
aureate72515283aureate
austere7312993austere
besetter10137983besetter
brunette1044723brunette
burettes1048953burettes
bustle84015483bus_tle
butte74924293bu__tte
caseate9314783caseate
casettes1039653casettes
cassette1047813cassette
culotte976893culotte
cuneate9311723cuneate
curetted1137173curetted
curettes1039313curettes
cuspate1138233cuspate
cuvettes1335323cuvettes
dinette8310013dinette
diskette1346753diskette
duetted937023du_etted
eustele738193eustele
fossette1145263fossette
fouette1038213fouette
frisette1195483frisette
fumettes1345773fumettes
fusee86224583fuse__e
galette84212703galette
gazette17357363gazette
genette838863genette
grisette994653grisette
hustle93113993hus_tle
insetted9249023insetted
insetter8218593insetter
justle133211583jus_tle
layette1037133layette
lisente71210703lisente
lunettes836753lunettes
lustre64011683lus_tre
maleate94117543maleate
maquette1946113maquette
matte75626843m__atte
mestee84523883mes_tee
metate82720533m__etate
mete64438133m__e_te
metre74821303m__etre
mettle83815723m__ettle
mimetite1247603mimetite
misate81222693mis_ate
miscite11314383miscite
misdate101413963misdate
misease92713043misease
miseat82925713miseat_
miseaten10310773miseaten
miseats92815793miseats
misenter10310833misenter
mismate111415353mismate
misrate91319143misrate
misstate10711343misstate
mofettes1386083mofettes
moffette1643493moffette
moquette1944973moquette
moste75925083mos__te
motte75526973m__otte
mozetta1894753mozetta
mozzette1842913mozzette
mulatto944733mulatto
muleta839233mule_ta
muletas937383muletas
muleteer1044703muleteer
mullite9313013mullite
muriate9313363muriate
muscae10410673mus_cae
muscat10314663muscat_
muscatel1246063muscatel
muscats1138933muscats
muscle10310973mus_cle
muse67136033mus___e
mused85524583muse__d
museful1245893museful
muser76024123muse__r
musers84719103muse_rs
muses75134303muse__s
museum1037703muse_um
museums1134573museums
musket122818203musket_
musketeer1542553musketeer
musketry1742183musketry
muskets13258643muskets
muskie123412543mus_kie
muskit122813253muskit_
muskits13278563muskits
muspike1536043muspike
must65145443mus__t_
musted93321073mus_ted
mustees94614923mustees
muster84724523mus_ter
mustered112511503mustered
musters94522513musters
musth105314783mus__th
musths11589483mus_ths
mustier94017963mus_tier
musts75527443mus__ts
musty105620953mus__ty
mutate83017483mu_tate
mute65136873mu___te
mutest84218053mutest_
mutt65739403mu__tt_
mutter84418883mu__tter
mutts75120253mu__tts
nauseate845893nauseate
navette1036983navette
noisette846313noisette
octette946423octette
omelette1045223omelette
palette93613983palette
pipette1137943pipette
poussette1143313poussette
proette9312363proette
resetter81511833resetter
resettle837303resettle
roseate7613453roseate
rosettes8310343rosettes
roulette847093roulette
rustle63615413rus_tle
sente56432883__sente
setae56026223__setae
sett45949053__sett_
settee63721023__settee
setter64023723__setter
settle63915663__settle
setts55124323__setts
strette7310763strette
syrette1037183syrette
tonette7310373tonette
tsetse664693_tsetse
umbrette1244943umbrette
unsettle866063unsettle
upsetter1034643upsetter
vedette1166003vedette
vidette1167543vidette

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.406440125.6
2DLD Change Limit1340271546.50020619.5
3Display Results1541540.0463347.8
 (SQL Overall)1786911546.95225703.5
 
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.